Hi, hope someone can help.

I have a master worksheet plus 52 identical worksheets (one for each week). On the master worksheet in cell A1 I have a formula that relates to Sheet2A1. In Cell B1 I have a formula that relates to Sheet3A1 etc all the way through to Sheet52 A1. I could manually input all these but is there a simple way of dragging?/ copying the formula across the master worksheet.