Lookup data from multiple sheets

[Guest]

I have a workbook that contains about 90 worksheets that represent business
units. I would like to create a summary page where there is going to be be
compiled data from each worksheet. Something like a lookup in multiple sheets/

 

[sanskar_d]

I have a workbook that contains about 90 worksheets that represen
business
units. I would like to create a summary page where there is going to b
be
compiled data from each worksheet. Something like a lookup in multipl
sheets/

Hi Denisa,

Try using Countif & Sumif functions for the summary sheet.

Also try defining names to ranges from all sheets (Insert >> Name >
Define)

I use this most of the time.

Hope this solves.

If not post a small example or mail me on (e-mail address removed)

Regards,

Sa