I'm trying to set up an "input spreadsheet" that will encompass data for several different forms that need to be filled out, ie, name, ssn, rank, dob, and completion of certain tasks. How do I reference the "input spreadsheet" from other sheets.

say A1 of sheet 1 is the number that I need for a position on sheet 3 how do I pull that number?

Sorry if this is unclear, I'm pretty new to working with Excel