Consolidation Macro for two different datasets

Hi everyone,
This forum has helped me in the past and I’m wondering if it can help me again. A task we have at work has proven to be quite onerous and I’m wondering if we can create a macro to simplify it. The task consists of two parts.

1) Taking a bunch of individual tracking sheets sent by workers and consolidating them all into one master sheet. The master sheet doesn’t require all the data from the tracking sheet so it’s a matter of selectively copying columns

2) This part is the harder one that’s stumping me. After the tracking sheets are consolidated, I need to insert other records in beneath the records already added, based on a tracking number at the beginning. This secondary sheet does not have all the columns from the first sheet either. As in there will be blanks in those lines where the secondary sheet doesn’t contain that data.
So what I need is a macro that hopefully could combine these two features together. Unfortunately, all I’ve managed to cobble together so far is something that copies all the tracking sheets together. Can anyone offer me any more help? I’ve included sample datasets with arbitrary data as an example of what I'm working with. The actual datasets we're getting are much larger (1000+), which is what makes a macro so necessary

Input Dataset 1.xlsxInput Dataset 2.xlsxInput Dataset 3.xlsxOutput Dataset Example.xlsx

Thanks very much!

This wokred great! Thanks!

Wondering if I can get a little more help. Worksheets in the books I'm combining aren't always named sheet1. Could this be replaced with a variable that takes the first worksheet in the book?