Do you want to copy all the data as well as formulas?

There is a way in Excel options to automate Excel to copy formulas & formats in Tables. From the Tools Menu select Options, then Edit & make sure that "Extend list formats & formulas" is checked.