I have a spreadsheet that has a summary sheet and multiple tabs. I have the
following formula in one of my summary sheet columns:

=IF('1300'!$F$9=" "," ",'1300'!$F$9)

-where 1300 is the name of one of the tabs and F9 within each tab is the
piece of information I want pulled into the summary tab.

The formula works correctly when I manually type it into any row with any
tab # within it, so I think the formula itself is ok. However, it's not
letting me drag the formula through the column and autofilling by changing
1300 to 1301, 1302, etc(representing pulling information off each consecutive
tab).

I already check that my calculation option is set to automatic and I've F9'd
about 10 times now. Any other suggestions?