I am working with an excel workbook that contains three sheets with a vast amount of data. I need to find data on sheets 1 and 2 that match sheet 3 then have the matching data entered onto sheet 4 (a new sheet).

Is there a function or a code that will allow me to do this, as cross referencing these sheets could take many hours as there is over 33000 entries.

If you want to post up a smaller excerpt of the main sheet with some sample data on sheets 1, 2 and 3 and a manual mockup of the expected results on sheet 4 from that sample, I'm sure I can help.

This can be probably be done on Sheet3 using formulas only and an Autofilter, so sheet4 wouldn't really be needed.

Or it can be done with VBA to sheet4.