Get Data from 1st file, only for specific values to 2nd file, Summary of all on 3rd file

[haste220000]

Working on a project where I have 3 files.

1st file will be used for order inputs for several warehouses (e.g. columns: Warehouse, Order, Date entered, etc...)

2nd file will be named based on warehouse and will require to Get Data only for that specific warehouse. This file will ha e additional columns, e.g. Ship Date, Tracking numbers, etc...

3rd file will Get the data for all specific warehouse files, will also have additional columns, e.g. Completed, Bill status, etc...

Could someone please help me.

I am between intermediate and expert with experience with macros, vba and novice with Get Data.

 

[jdellasala]

Surprising how long this has been sitting. This is clearly a job for Power Query. Rather than try to tell you how (without specifics), I'll point you to two great playlists on the subject.
Power Query from Mr. Excel, and Full Advanced Data Analysis & BI Class (MSPTDA). Power Query, Power Pivot, DAX, M Code, Power BI & Excel from Mike on the ExcelIsFun channel that have before and after sample workbooks.
Don't be overwhelmed, and be assured learning even the basics of Power Query will save you HOURS of work!