Macro to export from one excel file to another

I would like to make a Macro that exports information from one excel file to a master file. I have many files for different jobs that add all of the costs associated with it, and compiles it into 5 different categories. The master file is a listing of each job with the 5 categories listed across. (Each row is a job, and each column is a category)

We have run into problems with people making typos in the transferring from one file to the master, which is why I wanted to make a macro. I took a some classes back in my college days, and at one time I know how to do it (sort of) but that was a few years ago, and now I dont even know where to start.

Any suggestions?

Thanks in advance!

Sorry about that. Thanks for the suggestion!

I attached a workbook. Each sheet represents a different excel file. I would like to run a macro that takes the information in a job, and adds it to the next line in the master.

--My example has 4 jobs already in the master, and a 5th job is to be added.

--Job name, location, and date do not need to be transferred by the macro, but are in the master file.

--The data is vertical for each job, but horizontal in the master.

Hope this helps you help me!

Thanks again