Here is the question...

I have select data entries in multiple (=52*7) excel spreadsheets (separate files) that I need to collect into 1 spreadsheet. The format of the source table is almost always the same, and the title row of the column that I need to retrieve data from IS ALWAYS the same. Is there a way to save myself some time here, or am I destined to spend the next few hours in copy-paste world?

Thanks,
Rob