Hi,

=INDIRECT("'[Operator copy sheet.xls]Day "&ROW()-6&"'!$B$9")

Please note that the Day 1 sheet has a trailing space in the tab name that doesn't exist in the other tabs. Hence this formula will fail on the first row unless you correct the tab name.