Copying Data Between Cells

Hi there I am trying to copy repetative Data between workspaces. In excell the VLOOKUP function was used and it works fine.

I have 4 workspaces

  1. Mortgage Fact Find → this has a data such as name address mobole email DOB address postcode
  2. Mortgage Appplication → there is a lot od data in sheet 1 that i wnat to pull inot sheet 2 (celluar data)
  3. Mortgage SIGNOFF → this has data i need to pull from worksheet 2
  4. Mortgage NBR → This data need to be pulled from the previous threre shetts no human input

I wpuld appreciate if anyone could help me out here I have tried VLOOKUP and it just fails all the time