AutoFill from another Worksheet

[tekrepairsne]

Currently creating a Database in Excel for Jobs, Purchases etc.
For Jobs side, I want to be able to type in the Client ID (e.g. AAABBB01) then for it to automatically fill in:

• Surname
• First Name
• Business Name
• Address
• Town
• Postcode
• Home #
• Mobile #
• Work #
• Email

I want to put all of the Clients details in a separate worksheet, so in my main worksheet (Database) I want to be able to type in the Client ID: AAABBB01 then for it to automatically fill in the next fields as to the above details.

Currently using MSO 365.

Thanks in advance

 

[mumps]

In which column in the Clients details sheet is the Client ID? In which column in the Database sheet will you be typing the Client ID?

 

[tekrepairsne]

In which column in the Clients details sheet is the Client ID? In which column in the Database sheet will you be typing the Client ID?

Client ID in Client Details Sheet will be in column 'A'.
Client ID in Database Sheet will be in column 'B'.