Reference to Different File - Multiple Tabs

Hi,

I have often to these boards in search for answers to make my use of Excel more efficient. So before I even ask anything, I really wanted to thank everyone who contributes their time and effort into resolving the questions posted here. They help not just the authors but also, im sure, many strollers like myself.

Question: I am trying to link to a different workbook, which has multiple tabs. However, I would love to drag the formula down and have it automatically adjust the name of tab. These tabs are sequentially named.

='[DifferentFile.xls]Sheet 1'!$F$402

How do I change Sheet 1 to Sheet 2, Sheet 3, Sheet 4, etc. without having to manually type it in?

Thank you once again.

What does it mean to have a closed workbook?

That formula, modified appropriately, results in #REF!

Formula works! I was including an extra, unnecessary space.

Thank you! You just saved my torturous life haha..