I'm a moderately experienced Excel (2007) user however I'm not very well versed with VBAs and Macros which is what I believe I will need for my problem.

I have three sheets and on each sheet the first 5 columns (A – E) have the same title (all in row 1, frozen top row and with filters) there are other columns but I only need A –E to auto transfer.

Sheet 1 is named ‘Total’

Sheet 2 is named ‘Management Referral’

Sheet 3 is named ‘Health Assessments’

What I’d like is for any entry that goes into any row in both sheet 2 and 3 to automatically transfer to sheet 1, but only the information from columns A – E.

There will be dates (dd/mm/yyyy) in column A in each sheet and when transferred to sheet 1 they must be listed chronologically oldest to newest.

I also need all the information in columns A – E that transfer to sheet 1 to stay in their respective sheets.

Please let me know if any further details are needed – as I said, I’m really clueless when it comes to VBAs!

Thank you