I've searched the forum with little success so I am having to write to you all for help. I need a macro that allows me to select from a directory either an xls or xlsx file. Once selected I need the macro to copy all of the data from the range A2:Q800 from all of the worksheets which have data in them and append them onto sheet2 from where I invoked the macro. The sheet names and quantity of sheets (never greater than 5) will be completely different within each of the files opened. If anyone can help it would be greatly appreciated.

Thanks