I have a Spread sheet containing multiple sheets. There is a user sheet and then multiple read only product sheets

I want the user to be able to select a product name on the user sheet and then to auto populate other cells in this sheet with data taken from the corresponding product sheet.

I can do this using the INDIRECT function

For example I have a data validated list in cell B1 that the user selects a product from and, as the sheets are given the same name as the products, the following gives me the data shown on that sheet in cell B6

INDIRECT($B$1&"!B6")

And that's great but I want to now copy this code down to the next 100 rows and the B6 cell reference doesnt auto increment.

So

Is there a better way of doing this or can some one tell me how to easily copy, and auto increment, the code to other cells.

Thanks
Ian