Creating a Macro to compile from different Workbooks

[DirtyM]

I work with some software that generates various reports as excel docs. The naming convention is always the same for these documents. There are a total of 4 documents I draw from to make a final report. Most of the numbers on this final report are simple cut and paste from one workbook into the final report. I wanted to write the macro such that I can generate these 4 automated reports, put them in a folder and hit run. There are a few other things I would like to do but this is the start. Some numbers off the report will give a time. I must generate a timeline that is preset based off a time in the auto generated report. There is also some info on the report that has to do with large data bases for example sun rise and sunset. I was going to just use vlookup for this. Can anyone help offer a meat hid to do this? Also the auto generated reports don't necessarily have proper formatting to merge into the reports so that reformatting the cells will have to be part of the macro.

 

[akmatz]

Can you post some sample data?