if its exactly the same data you could just right click on the tab and Copy
the whole page (right click - copy,, make sure the tick in in create a copy)
will make a duplicate of the page wittout the need for formulas or macros