|Maybe I'm missing something, but why won't a simple SheetName!CellReference formula work?|
Assumptions, modify as required:
1 - Sheet1 is your summary sheet
2 - Sheet1!Row 1 contains Column headings
3 - Sheet2, Sheet3, etc. contain your data
In Sheet1!A2 enter:
In Sheet1!A3 enter:
Continue down Column A until all of your sheets have been referenced.
Select the entire range of formulas and drag them to the right as far as required.
If Row 2 of the various sheets are of different lengths, enhance the formula to return a blank cell if a cell in Row 2 is empty and then drag the formula as far right as the longest Row 2 requires...
I can provide a macro if required, but I don't see a need for one - unless I'm missing some detail of your requirements.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03