You can create a complete copy of any sheet along with all its contents (data, formatting, formulas).
Duplicate a sheet
1.Right-click the tab of the sheet you want to copy.
2.From the context menu, select the Duplicate command.
A copy of the original sheet will appear next to the original sheet tab. The new sheet will become active.