I am looking to be able to run a macro that will allow me to choose a folder with all of my workbooks and set the first tab name to equal the value of cell B7. All the workbooks are the same. Ideally it would open a file, make the tab name equal to the text in B7, save-as, close, open the next file and so on until the files have all been run through inside the folder. I am pretty new to the macro world so bear with me. Thanks in advance!