How do you make a duplication of a worksheet in Microsoft Excel?

Open both documents. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the other document.