Transferring columns with same titles to another sheet automatically - with entries to lis

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

Could VLOOKUP, MATCH and INDEX work? Instead of VBA?

Better if you provide a workbook...

Vikas Gautam

Hi Vikas,

Thank you for replying - I know that I should provide a workbook but I don't think I can just yet!

To be honest I think I may be been a bit too convoluted with my initial description.

Basically each sheet has the same 6 columns A - F (each sheet has different columns after F)

A B C D E F
Date Consultant Client Service Required Price Contacted


I would like each row and column to fill in sheet 1 whenever sheets 2 have entries in, but only columns A - F. I would like the information to stay in sheets 2 & 3 and for it to just copy to sheet 1.

However once columns A - F copy from sheets 2 & 3, all information must be detailed oldest - newest.

I hope this makes sense!