Best to start a thread of your own. Attach a sample workbook showing what you're wanting to accomplish. Use multiple sheets in the workbook if necessary to indicate BEFORE/AFTER results.

How can you link the same cell in various tabs on the one spread sheet to 1 master sheet compiled?

Link in the cells with the many examples above into your summary, then add them up.

If all the sheets are adjacent, you might try this 3D Sum formula, edit for your first and last sheet names in the group:

=SUM(First:Last!A1)

I have a problem. I have a list about some pupils and I have already linked them another tables as you told me (Because they are in different classes). But now I need to sort these pupils in the main table by their grades. If I do this, it will also effect to another tables, and there would be wrong information. So my question is that can I link by pupil's names? Thank you for your help in advance!

Yes, you can lookup data from a table using pupil's names. Read up on the VLOOKUP function.

This deleted my my entire second sheet. -_-

Formulas cannot delete anything from other cells, only display results in the cell where they are entered.

Hello

I have an xls file with 10 sheets from different customers with different database, but in this worksheet I have a page which I have summarize the most important date of them , but know I want to make a link between with the summarize page and each customer. For example if when I click on customer who has been named Jame , then the page of this customer come up or switch on this page , what shall I do ?

Start a new thread here on the forum with your question.

Then click GO ADVANCED on that new thread and use the paperclip icon to attach your sample workbook so we can look at it together.
Thanks.