Copy formula from one sheet to anotehr and change the corespening sheet name inthe formula

Hi, I am new to the form but other member questions has helped me alot in the past - Thanks

I have a problem that is a bit difficult for ne to explain but I’ll try

I have a Master workbook that updates from 3 other workbooks. Each workbook has a master sheet and then 30 worksheets. My problem is I want to copy formulas from one worksheet to another worksheet in my master and change the corresponding reference worksheet.

Example:
How do I copy the formula into Sheet3 A1 of the Master Workbook and have the corresponding sheet updated in the formula (should read: '[Workbook1]Sheet3'!A1+'[Workbook 2]Sheet3'!A1+'[Workbook 3]Sheet3'!A1) If I copy the formal from sheet1 the formula stays the same (Workbook1]Sheet1'!A1+'[Workbook 2]Sheet1'!A1+'[Workbook 3]Sheet1'!A1)

Master Workbook
Sheet1 A1= '[Workbook1]Sheet1'!A1+'[Workbook 2]Sheet1'!A1+'[Workbook 3]Sheet1'!A1
Sheet2 A1 should be = '[Workbook1]Sheet2'!A1+'[Workbook 2]Sheet2'!A1+'[Workbook 3]Sheet2'!A1
Sheet3 A1=

Workbook 1
Sheet1
Sheet2
Sheet3

Workbook 2
Sheet1
Sheet2
Sheet3

Workbook 3
Sheet1
Sheet2
Sheet3

Any ideas?

Thanks