Moved my document now formulas dont work

I have created two documents. One document (A) is my worksheet where I input data, the second document (B) is my spreadsheet where it comprises all my data into the fields I want. I have completed both documents on computer (1) and now need to transfer it to another computer (2). However my formulas no longer function after I move the document (A) from computer (1) to computer (2). Is there a way for me to work around this? Do I need to transfer the spreadsheet (B) to computer (2) in order for them to function correctly? How can I make it so I have the worksheet (A) on computer (1) enter data correctly into the spreadsheet (B) on computer (2)?

Simply emailing or copying an Excel file from one source to another should have no impact.

Are the worksheets targeting other files?

If this is the case, your links need to show actual filepaths instead of folders relative to the position of the file.

yes the information entered into the worksheet is distributed to the spreadsheet which is another document (and preferably stored on another or multiple other computers). how would I show the actual filepaths? do I need to redo all my formulas in order to achieve this?

great thanks, recreating folders on the new computer will work just fine