Extract data from a workbook with multiple tabs, into a workbook with corresponding tabs

I have a customer order form that has data on multiple tabs, different layouts on each, (copy included) and im looking to transfer this data to another workbook that has other functions for data preparation(Also included). I have used links in the past but its not working correctly and rework on it happens alot. I am looking for a macro/script that pulls this information from one tab named, for example, "Med" and inserts it into another workbook with the same tab named "Med" most likely cell by cell
-information is pulled from top to bottom orientation and inserted to a left to right orientation
-New tabs can and are added so updating is a must.
-The only form that can be edited is the Order Generator
Any Help would be appreciated.

Attached:
Customer Order
Order Generator