Copying rows to another sheet based on date range

Hi there,

I am really struggling with this one. We have a massive spreadsheet at work that contains 10 tabs that all have lots of data. We need to report on the newly added data each week and at the moment a staff member is finding and retyping this manually. I know we could filter and copy paste each tab but I would REALLY like a macro that would do this automatically when a date is entered into each of the tabs.

What we need is if the date entered into one column on each sheet is within the past week, at least after a specified date that can be easily changed (at the moment I have a date entered on the "reporting" tab) that row is copied into the "reporting" tab. An additional challenge is that the date column is not the same on each tab. If this is a huge problem I could potentially move things around.

I am pretty new to excel and have tried to work out formulas to do this and have had a play with macros but am failing miserably.

I have attached a smaller version of our spreadsheet as a reference. It still has all 10 tabs and all the headings that are included.

Any help would be greatly appreciated!