How do I combine 2 sheets of Data on a 3rd sheet in the same workbook

I am trying to build a report template but have to source specific data for the same project numbers from separate reports. At times there could be well over 5k lines of data on each page, so I want to copy and past them into the template and then run a macro to combine the information on a 3rd sheet.

Maybe:

Please Login or Register  to view this content.