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.