Want to pull values based on same cell # but from multiple sheets

[pamnc]

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 [COLOR=blue !important][COLOR=blue !important]Backup[/COLOR][/COLOR] - 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

These would need to be in increments of 1. I have sample spreadsheets I can send.

Thanks in advance for any help!

 

[RonB1111]

Here's a link explaining how to sum the same cell across multiple worksheets:
Sum the Same Cell in Multiple Microsoft Excel Worksheets

 

[pamnc]

Thank you!!