How to populate the cells in one sheet with data taken from a user selected second sheet

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

Here you are.

Note I have copied the Indirect equation down to demonstrate the problem. Ideally I would copy this equation down, and it would auto increment so that I would see -2, -3 ,-4 etc

Thanks
Ian