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!