Copying info from the same row in multiple tabs

[rpikover]

I am working with a workbook that has lets say 40 tabs in it. I want to create a summary tab. each of the 40 tabs are formatted identically and I need to extract info from the same exact cell from each sheet and put them in a row on the summary tab essentially creating a column with 40 rows of info. make sense? is there a way to do this?

 

[plettieri]

Hi:

Something like this might work....

If the sheets from which you want to sum A1-values are all re-named, then insert two new sheets and name them First and Last. Place all the relevant sheets between First and Last and use the formula...

=SUM(First:Last!A1)


plettieri