I've got a Globally Defined Name "BusName" that equates to
{=INDIRECT(dbName&"F4:F"&dbLastRow)}. It serves as a lookup array to a range
of cells and works as intended. "dbName" and "dbLastRow" are also names where
"dbName" is the name of a particular Worksheet and dbLastRow if the number of
the last row containing data on that Worksheet.

While upgrading the analysis spreadsheet, I attempted to move "BusName" to a
cell on a worksheet thus replacing the Defined Name; "BusName" now points to
the same formula but within a cell. Now, "BusName" returns only the first
cell of the array referenced by {=INDIRECT(dbName&"F4:F"&dbLastRow)}.

Why does the same formula with the same name built with the same variables
act differently on the Worksheet level as opposed to the Workbook level? The
formula includes the worksheet name so the reference appears to be complete.
What gives?