Sharing a Workbook with with connections to another workbook

Okay trying a new Method for my issue just focusing on the Master Sheet I, trying to use a range formulat such as
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$F1:$L$1)
but it only works when I break it up for each cell like so. Which is impracticle due to this needing to be re written every week.... Please assist.

"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$F$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$G$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$H$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$I$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$J$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$K$1)
"=('S:/Common\Location\Location Weekley Schedule\City\[City Attendance sheet.xlsx]6-22-15'!$L$1)

I should mention that when I don't break it up the first 2 Cells give me a #VALUE! error