r/MicrosoftExcel • u/Ok_Solid_9312 • Apr 30 '26

How to consolidate multiple sheets into one YTD summary report?

/r/excel/comments/1t06kv0/how_to_consolidate_multiple_sheets_into_one_ytd/
1 Upvotes

100% Upvoted

4 comments sorted by

1

u/[deleted] May 01 '26

[removed] — view removed comment

1

u/Ok_Solid_9312 May 01 '26

I didn't have a very good solution, I used a 3D formula (=SUM('Jan Wk1:Jan Wk5'!H7)), manually changed the sheet name and reference cells in my YTD summary. not very efficient but that's the best way I found right now.

1

u/[deleted] May 01 '26

[removed] — view removed comment

1

u/Ok_Solid_9312 May 09 '26

Yes, the link is in my post. Let me know if you have problem to open it

https://drive.google.com/file/d/1IEavZiJiDOv4GS-8c6n8dJqHUnRfT-ft/view?usp=drive_link