How can I create a Report that pulls data from both rows and the summary of multiple sheets?
I am looking to create a Report that consolidates data from multiple projects. I have a sheet for each project which includes Summary fields for each with items like Project Name and Description. I have a single row in each sheet for the data that changes month to month. e.g. Current spend to date.
What I'm looking for is a Report that combines both.eg.
Project Name Description Spend to date Budget
Project A Implement new system 100 200
Project B Deliver new PPE 500 1000
Is the above possible?
Thanks for any help you can offer.