Worked!!! Thanks a ton! There is just one last thing that employees are running into. I have around 5 worksheets pulling into one master so it gets pretty long. When someone updates a sheet they have to back and delete the entire master (minus the header). It would be much more convenient to the user if it auto deleted the master (minus the header) and then repopulated it every time the macro was run. After that, I haven't received any complaints. Can't thank you enough for your help. This has saved my company a lot of money on more expensive alternatives.