Forum Discussion
Solved
How to link Excel Tab Data to a Summary Page
Hi there,
I am trying to create a workload task tracker/log, with existing Data.
Is there a way of linking several Excel Tabs to a main Summary Page?
Is there a quick way of doing this?
I would like the Summary Page to provide an quick overview of the tasks outstanding, automatically, save going into each individual tabs.
I have searched online and looked through various templates, but I cannot find any information on this.
Many thanks in advance
Eluned
- This question is asked very often. Be forewarned, you may get responses advising you to consolidate the sheets (A good idea). I understand you may have to use this arrangement so I'll refer you to this discussion:
https://techcommunity.microsoft.com/t5/excel/pulling-data-to-a-summary-sheet-from-select-cells-in-many/m-p/1767919#M77553
2 Replies
- This question is asked very often. Be forewarned, you may get responses advising you to consolidate the sheets (A good idea). I understand you may have to use this arrangement so I'll refer you to this discussion:
https://techcommunity.microsoft.com/t5/excel/pulling-data-to-a-summary-sheet-from-select-cells-in-many/m-p/1767919#M77553- Thank you!
