I have an issue. I have a whole bunch of files in a folder with various different names. The files I want to merge have the word REC at the start of the file
e.g REC_012014.xlsx, REC_022014.xslx..etc. They all have the same format, and I just want to extract the first sheet with range A1:D50 in all the files and merge them into one excel file. How do I go about doing this?