I have been all over the place with this one. What I'm looking for is a small piece of code to do the following. I get a monthly file with the turnover from departments from multiple states. I the files are stored on the Y:drive Every month the send the file in with a slightly different name example. Jan16 or January 2017 or 010117. I have tried a variety of things and decided it would be better if I could just use an inputbox to select the file, open the file, copy the four sheets i need from that file into the Master Rentention file (Ohio, Arkansas, Tennessee, and Texas) I don't mind the manual process but i have someone who puts the data together for me when I'm not available and (trust me) they need a button to click. Any thoughts? Your help is greatly appreciated.