Copy specific cells from multiple workbooks and import them to a master workbook

I have created a simple form in excel for an employee time card and there will be a time card for each employee. At the end of the day the data needs to be input into our ERP system. I was looking to write a macro that takes the data from all the time cards and drops that data into a master file. From the master file i will then export the data to a .txt file with a fixed width. I have the export to a .txt file figured out already but I am having issues with getting the data from all the files into one. One of the issues is that the data is not lined up in straight-forward columns and rows otherwise easily import it. The macro needs to be able to select the cells with the data and import it to the master file in a simple row/column layout. I have attached a copy of the time card to get a better understanding. There should be a row for each job number. Let me know if more explaining is required because it is somewhat confusing to explain. The remarks column is not needed and I have removed the data from the lists below but that can easily be filled in with sample data and will appear in the drop down boxes.

Timecard.xlsMaster.xlsYou can just copy the time card three times if you want. On this attachment you can now see how that data will look. I just want to know if there is a way to grab all of data(of which you can now see) in the in the entry areas. I have tried linking the data and copying the cells with a macro but that will not work with the drop down boxes. You can look at the master file to see which data that I need. The reason I want to do this is we are looking to have the employees enter the information on a tablet so there a few compatibility issues with the tablet app. The drop down boxes are being used to reduce employee error by not having them type in the data.

Thanks a lot I'm slowly getting the hang of VBA so this helps me out quite a bit.