Link an Excel Online Spreadsheet as a new tab in a separate Excel

Hello,

I apologize but I dont have a sample I can post. I have a Excel an Excel spreadsheet stored on my own drive where I enter order info. After I update it I have to copy some info on order numbers to another spreadsheet stored on a Onedrive where ppl from different areas go in and update it. Is there a way I can save a live copy of the Excel on Onedrive as a new tab on the Excel in my drive so I can do a lookup to check that all the orders were inputted into the Excel on Onedrive

Try this I hope that helps
You can save a live copy of the Excel spreadsheet on OneDrive as a new tab on the Excel in your drive. Here are the steps to do this:

Open the Excel spreadsheet that you want to save on OneDrive.
Click on "File" in the top left corner of the Excel window.
Click on "Save As" and select "OneDrive" as the location to save the file.
Choose the folder on OneDrive where you want to save the file and click on "Save".
Once the file is saved on OneDrive, go to the Excel spreadsheet on your drive where you want to add the new tab.
Click on the "+" icon at the bottom of the Excel window to add a new tab.
Click on "From OneDrive" in the "Templates" section.
Select the Excel file that you saved on OneDrive and click on "Connect".
Follow the prompts to connect to the OneDrive file and select the sheet that you want to add as a new tab.
Click on "Load" to add the sheet as a new tab in your Excel spreadsheet.
Once you have added the sheet as a new tab, you can use lookup formulas to check that all the orders were inputted into the Excel on OneDrive.

thank you. I dont see the step "Click on "From OneDrive" in the "Templates" section. after clicking on the + where do i see templates?