On a daily basis I have to consolidate data from different workbooks into a master sheet. I am looking for a macro that can automate this task. I found some code on this site which is ideal, however when I run it it is not copying any data. I am new to VBA and I cannot find out what is going...