Excel VBA script to consolidate data

I need an Excel VBA script written to append data to a master worksheet. Example Scenario I have a new & empty workbook [login to view URL] I have multiple files, all of which contain 1 worksheet. I need to copy specific data from the worksheet and paste it into the master worksheet. The range of data may vary. The range of data to be copied usually starts at cell A6 and ends P##. There is always a blank row following the last row of data to be copied. So you’ll need to dynamically find the data range. It would be nice if I could select multiple files at a time, or at least point to a file directory and have the script process all files that exist.