Summarize data from multiple worksheets

With this VBA code.

See the attached file.

Please Login or Register  to view this content.

My tactic is to use Worksheet level names and the INDIRECT function.

For example you name a cell on each contributor sheet 'MyTot'. It does not matter where on the worksheet the cell is named.
You can collect the MyTot's from each sheet using the formula =INDIRECT(A! & "!MyTot"), where the cell A1 carries the name of the worksheet.

I include an example workbook.

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.