Pulling data from worksheets

[blues2]

Im sure its here already but I cannot find the answer:

I have 10 worksheets with lists of data in the same excel file.
I want to have a summary worksheet that automatically pulls the actual information on the 10 sheets to give complete list in summary.

Can anyone help me please?

Thanks

[maybelle]

I would suggest linking to the values (easy way is to paste special> paste as link, which prevents you from linking everything manually), but it really depends what you want to do. maybe give a bit more info?

[blues2]

I dont want to have to check all the worksheets individually to copy and paste.

It is about 10 worksheets on separate tabs in the same file. There are references that are added to daily on each of the tabs.

What I would like is once the data is added to one of the tabs it will auto-populate the summary sheet as well.

Perhaps some sort of formula that checks if a cell contains text. If there is text then it would automatically copy that text to a new cell.

Thanks for your feedback