Lookup data from multiple sheets within a date range

[Brilly]

Hi,
I’m hoping you can help me, I stupidly said I could help a colleague with his excel sheet but this is proving way beyond my knowledge.

I have multiple sheets for tracking spending from different budgets. On the final sheet I want to be able to pull all the row information from across all sheets that correspond to a date range I set on the final sheet.

Any help would be greatly appreciated

Thanks

 

[Tupe77]

We need more information about the structure of your data to be able to help. The forum has a very good tool for that and I recommend you check it out: XL2BB - Excel Range to BBCode

 

[Brilly]

We need more information about the structure of your data to be able to help. The forum has a very good tool for that and I recommend you check it out: XL2BB - Excel Range to BBCode

Thank you I will try and sort that later.

The structure is simple though. 10x sheets each with a table that is manually filled in. On the final sheet I want to pull all the row data from all sheets that match the date range I set in the final sheet.