How can I transfer data from one spread sheet to another?

Hi,

I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data transfer to another spread sheet at a trigger cell. For example

Spreadsheet A has the client's info, payment, appointment, date, doctor and a lot of other details and finally "how much the client owes" in "how much the client owes" I want it to automatically trigger just the info I listed above to Spreadsheet B.

In other words,

What I want transferred to Spreadsheet B is all of the above info but I want it transferred ONLY when I type in the amount the client owes in Spreadsheet A. Once I type that in Spreadsheet A, I want all of that to transfer to Spreadsheet B.

How Can I make this happen?

Thanks in advance for any guidance!