I need to pull a list of values from multiple sheets in another file. Eventually will need this to go from Sheet 1 to about 200. Hope there's an easy way & can replicate this formula all the way down so I won't have to keep changing the Sheet# for each.

Here are the values I pulled as an example & the formula used beside it.

Thanks in advance for any help!

Contract#
BE1308 ='[2013 E-Flyers Results Backup - Fishing.xlsx]Sheet1'!$B$6
BE1292 ='[2013 E-Flyers Results Backup - Fishing.xlsx]Sheet2'!$B$6
BE1290 ='[2013 E-Flyers Results Backup - Fishing.xlsx]Sheet3'!$B$6