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!!!