Using Indirect function

[fucell]

Ok, I want to have a formula that will fill automatically the specific cell using indirect formula. for example.

in sheet1 I have blank cells b1 c1 d1 etc.

and I have data base in sheet2. if im going to click across the rows in database like for example Rows("11:11").Select, those selected data will fill in sheet1 in b1 c1 d1. Hope you get it.

thanks,

fucel