When I create a new workbook.

I have sheet1 as my OTS(one true source) or Master list.

When I enter the information on certain cells let's say in A1 I enter 100 I will like as I enter the data from the master worksheet to duplicate on Sheet 2 either in the same cell of Sheet:A1 or Sheet 2 on another cell let's say sheet 2:C3.

What is the formula to do something like this ans also to duplicate it in a way that when I create a new sheet the formula carries over so I don't spend the time entering the formula in the cell for every new sheet..

Thanks!