Changing Reference Sheet's Name while dragging the formula down

[vir8nitkkr]

In the formula given below, I want that while dragging it down the Roll-1 should be replaced by Roll-2 and then Roll-3 and so on in coming rows of the column. How to do so? Please help.

Formula ='[Hobby Card Macro Enabled.xlsm]Roll-1'!$B$6

 

[ndsutherland]

Try

=Indirect("'[Hobby Card Macro Enabled.xlsm]Roll-"&row($B1)&"'!$B$6")

 

[vir8nitkkr]

That WORKED! Thanks Man!!