Hi Nadine,

Yes, there is a way to copy formulas from one workbook to another and have them reference the cells in the new workbook instead of the original workbook. Here's how you can do it:

1. Open both workbooks in the same Excel session.
2. In the workbook that contains the formulas you want to copy, select the cells that contain the formulas.
3. Press Ctrl+C to copy the cells.
4. Switch to the other workbook where you want to paste the formulas.
5. Select the cell where you want to paste the formulas.
6. Right-click the cell and select "Paste Special" from the context menu.
7. In the "Paste Special" dialog box, select "Formulas" from the list of options.
8. Check the box next to "Values" to paste the values of the formulas instead of the formulas themselves.
9. Check the box next to "Skip blanks" if you want to skip any blank cells in the selection.
10. Click "OK" to paste the formulas into the new workbook.

The formulas should now reference the cells in the new workbook instead of the original workbook. You can repeat these steps for the other 50 workbooks you need to copy the formulas to.