Copy and Paste to multiple sheets

[retiredjhawk]

I am using Excel 2016 on Windows 10. I have 40 sheets in my workbook. I was able to copy cell K30 (=Sum(B30:J30)) from Branca in another workbbook (Summary& Weekly……) to Branca in Workbook 2 into cell M2. The actual formula in M2 in Workbook 2 turned out to be this: ='[summary&weekly2015WeekFINAL2.xlsx]Branca'!$K$30
I want to copy the same cell K30 from Buzzard in the other workbook to Buzzard M2 in Workbook 2. And into the other 38 sheets with different names in my workbook 2. When I tried COPY/PASTE from Branca M2 in Workbook 2 to Buzzard M2, I got the info for Branca in the Buzzard sheet. How do I get the formula to link the two workbooks on different sheets?

[vlady]

go to the Formula bar then highlight the formula. Copy
paste it to the other workbook.
or
Copy all the formulas paste it to the target cells then then go to Edit -> Links
There you can change the source to your current sheet.