Every week I get a flat report that has the same column headings. The files are always named differently due to the dates and other reasons. I'd like to start a master workbook and have a macro that prompts me to locate the new weekly file, select it, and add the new rows.

Attached are some examples of recent files

RDC SE WE 08.18.2012.xlsxRDC SE WE 08.11.2012.xlsxRDC SE WE 08.04.2012.xlsx