Importing Data from Multiple Excel Forms into Single Summary

I am trying to take a Service Report that our employees fill out and create a summary excel file that lists all the information from the individual reports in a central "database" I saw the thread http://www.excelforum.com/excel-prog...-take-2-a.html which was helpful in quickly pulling the data into one excel file. I however need my new file to have a header telling what data each column contains, I would prefer to not have to do this manually every time. The columns will always have the same information. I am not opposed to using macros instead of the add-in I have written basic macros before and am fair at writing code.

This thread: http://www.excelforum.com/excel-prog...ngle-file.html was helpful, and I have been able to adapt it to my uses.

I have edited the code to place the name of the original files in column A, it makes it a little easier to cross reference back to the originals.

Please Login or Register  to view this content.

started this thread trying to figure out how to have the files be able to write into multiple sub -category tabs: http://www.excelforum.com/excel-prog...ml#post3735101