Vlookup question

OK, Ive got a pretty good brain teaser here.

I have 2 pages setup, one called database, and one called brochures.

I want to be able to pull data from the database page to the brochure page.

Now heres the catch, on the brochure page I want to be able to select from a dropdown list (which Ive already got), any one line item from the database page and have the rest of the cells on the brochure page fill in automatically.

If my dropdown list in A1 of my brochure page selects item A1 from the database page, how do I get B1 of my brochure page to reflect the data of B1 on my database page. But most importantly, if I change the selection of my dropdown list (A1 of my brochure page) to reflect A2 on the database page, how do I get B2 on the brochure page to reflect the data of B2 on the database page?

Any and all help will be greatly appreciated!!!

Little confused here on your exact requirements. Are you saying if A1 on your Brochure page = A2 on the database page, you want B2 (instead of B1) on the Brochure page to equal B2 on the database page? What would you want then in row 1?
From how you've written the request, in B1 of the Brochures page, you can type =IF($A$1=Database!$A1,Database!B1,""). Then you can drag this to the right and down. If you want all the data in row 1, use =VLOOKUP($A1,Database!$A$1:B100,Column(),False) and drag to the right. You will have to adjust the number of rows in the array as necessary.