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

Is there another way of completing this by creating a script to pull data from the order form and printing it to a comma delimited text file?

I solved it, I used the macro recorder to copy each cell and paste them to the sheet needed, then used a button to call that macro, cleaned the code up a little and let it be.