Creating a total sheet for all other sheets in workbook

[saintvinni]

I need to create a total sheet which gives me specific information from all the other sheets in my workbook. All sheets are formatted the same. I dont want to individually click each cell in each sheet to create this. Is it possible to auto fill so the totalling sheet will find the info I need?

I have attached an example sheet with one row filled out. Id like the other rows to pull info from the other sheets.

[Aardigspook]

One method would be to use a helper column with the worksheet names and a helper row with the cell references, then use Indirect.

Try this:
1. Insert a new column before 'Date' - new column D.
2. In D3 to D6, type in the names of the worksheets which refer to the vintage/varietal/vineyard (19 VIO C4 Al, etc).
3. In the blank row 2, insert the references of the cells you want to pull information from on each sheet, under the appropriate column heading. So 'C1' under 'Date', 'I1' under 'Tons', etc.
4. Now put this into E3 (note the dollar signs):

Please Login or Register  to view this content.

5. Right-click and drag E3 to the right, to J3, release the mouse button and select 'Fill without formatting'. (If you left-click and drag, you'll format F3 to J3 as dates - right-click-drag means you don't have to reformat).
6. Leave E3:J3 selected (or re-select if you clicked away) and drag down to row 6 (left-click-drag is fine here).
7. Optional: hide column D and row 2.

Hopefully that will give you what you need. I've attached your file showing this working.

[saintvinni]

THANK YOU! This help forum is great. I always get great advice and its super quick. Thank you again for the help.

[Aardigspook]

You're welcome, glad I could help.

If you're satisfied that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.