Using variable from Input box to identify a cell

I have a spreadsheet with various clients names, phone numbers, etc on Sheet 1. Each client has an ID number assigned in Column A and the data I need is in various cells in one row (eg: Name is in C9, ph. # is in D9, email is in H9). Sheet 2 has a form that gets printed out and given to the clients. I would like to have a macro or VB code to fill in the name, phone number etc. on the form based on which client is selected from Sheet 1. What I've got so far is an Input box where I input the client ID number. However, I've been unable to use this variable in the various cells on the form to fill in names, phone numbers, etc. What I was hoping to do is something like this:
='Sheet1!'vairable9 if I had entered 9 in my Input box.

In your case, I think it would be best to attach a file so we can better visualize what your beggining sheet looks like and what the form looks like.

You might consider something like this.

Please Login or Register  to view this content.

Client List.xlsmVLookup may be the better way to go but here's a sample of my spreadsheet. I need the Name, phone numbers and email address to be filled into the form.

Yes that works great! Thanks.