Unfortunately I am using a macro in a separate workbook to pull data from each slide distribution day workbook, but the data will only pull if a workbook is titled Test Slide Distribution on the right path. The previous owner has many different cells tied to the specific naming conventions and it would take even longer to go through and change all of the necessary cells, also the cells that need to be copy and pasted must be changed occasionally to reflect new employees and so on. I ended up just manually resaving each one after pulling the data I needed. Thank you for the help though! If anyone else has an idea of a vba function at the end of a macro to copy something specific to the clipboard as text please reply!