Excel spread sheet help using a data base

[Seawitch2]

I am setting up a spread sheet (sheet 1)that I want to automatically fill based on a data base (sheet 2).

I tried using =vlookup but it does not seem to want to acquire the data.

[#2]

Attach a sample workbook. Show your input and desired output. Explain in brief what you want.

[#3]

Try to use Indirect formula with link
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3
A4 B4 C4 D4 E4
A5 B5 C5 D5 E5
A6 B6 C6 D6 E6
Sheets Sales Tyres Tubes Spares Service
Sheet2 20 4 7 6 10
Sheet2 16 11 8 2 20
Sheet2 17 17 2 2 18
Sheet2 11 10 12 8 2
Sheet2 15 15 8 4 18
Formula is =INDIRECT("'"&$A7&"'!"&B1)
It indirectly link with sheet with data by reference.

[#4]

@sivakumarrj   What I am trying to do is fill in sheet 1 with a lookup from sheet 2.  If I put an FSA number in the form I want it to look up the information associated with FSA 4 on sheet 2  So if I put 280 in the FSA blank I want the information under name and club to fill in from the sheet 2 which I set up like a data base with all the FSA numbers listed with their info.  Hopefully that made sense.  Thanks

Sheet 2 data base.

FSA#	Last Name	First	Club
4	Adams	Carol	Hawthorne
5	Adams	Charlie	Hawthorne
153	Bessette*	Dorine	Coronado-Mainland
210	Boskovitch	Mike	Parkwood Oaks
220	Bove	Corinne	Southern Palms
280	Burrell	Rich	Deland

Sheet 1

1.  NAME			FSA#	280	CLUB
NAME			FSA#		CLUB
2.  NAME			FSA#		CLUB
NAME			FSA#		CLUB
3.  NAME			FSA#		CLUB
NAME			FSA#		CLUB

[#5]

Have a look and it will solve your issue.

[#6]

I know what I want it to look like, how did you get it to automatically fill in the blanks....what is the formula?

[#7]

I want to thank every one for all your help. It turned out to be more complicated than could be explained over the internet. Very complicated for me to understand. This was the answer...
=VLOOKUP($B10,FSADB!$A$2:$D$564,2,0)