Dooley Worksheet.xls” (that means for my example “Dooley_Worksheet.xls”). 2. Open any other Excel workbook that has an equal amount of data and edit the workbook. I have mine as Project, and then all my workbooks with data from the same test are grouped, so you should do that next. This will allow multiple people to work on your project at the same time. Step 1: Open any other workbook (I have mine as Project and then all my workbooks with data from the same test are grouped, so you should do that next.) Open your new workbook as an Excel tab. Step 2: Create a new worksheet in your new workbook. Step 3: Drag and drop the existing worksheet in the tab you just opened that you want to edit into your new workbook Tab. 3. Right-Click the 'workbook' icon and choose 'New Workbook…'; in the 'New Workbook' window, name your new Excel file project. Step 4: Open your Excel workbook. Step 5: Where the 'New Workbook' window is called “Name: Project Name”. 4. Open the old worksheet and enter a single value in it from the 'To' tab, or you can go to 'Get Data…' and enter the values from all worksheets in a single place. Step 6: Delete the old worksheet or leave it for last. Then, paste (or move, copy and paste) the new worksheet to the new workbook. You are now set up to have new and old worksheets for each data source. I have multiple files, and I can see changes from my other files as I save them with an Excel file. I hope this post was helpful to someone. Furthermore, I have my questions or comments below.