Hi Guys,

I was wondering and need help with a macro that does the following:

Copies columns E, A, B, and K (in that order) from one file (in a diff. folder) to another file (the file that will have the macro) in a tab that needs to be created called "Sumamary". this will change every month

I then need the macro to copy every cell that contains data in column D from each tab in the workbook that has the macro.

then I can do a quick vlookup to see if there are any variances....

thanks!!