Summarise data from multiple sheets based on dates

I have a workbook that contains four sheets. Each sheet is for a specific area, but the data on all the sheets is similar.

I would like to summarise the data from all the sheets onto a new sheet that can be viewed and printed, but cannot be altered by the user. The only time the sheet will change is based on changes to the other four sheets. Hope that made sense!!

I would like to use the date as the 'source' data so that any row that has a date of more than 2 working days ago (monday to Friday) will appear on the summary sheet.

Can anyone help? I have added a sample of what I currently have.

Thanks in advance.

Thanks for the reply.

Essentially, for each of the 4 sheets, if the date in column 'A' is 2 working days older than todays date, then it will copy that row to the summary sheet. So for every row, in all 4 sheets, if the criteria is met it will be copied to the summary sheet. The summary needs to show which area the row has come from.

I then need this sheet to be viewable/printable but not amendable.

I have added a new workbook to show how I would like the summary sheet to look. I have highlighted in yellows the data which needs to be copied from each of the 4 area tabs (ie, they are more than 2 working days old).

So I Managed to piece this code together which does most of what I want for an individual sheet.

Could anyone help me to adapt the code to do the same for all of the 4 areas and also into column D what area the data came from?

Code so far

Please Login or Register  to view this content.

With some help I have managed to get this code which does almost everything I need.

I now only need help with the criteria to copy the rows. The criteria I need is if the date in column A is 2 working days before todays date. Can someone please help?

Current code

Please Login or Register  to view this content.

Thanks.