Linking a table in Excel 2013 to data from another spreadsheet

[ruthhicks999]

I am trying to redesign some reports along the lines as to what I had at
a previous workplace. Can anyone help me work out how it was done.

The reports spreadsheet has a sheet called 'Outstanding Call Details'
this contains a table. Each cell in that table has a reference in it
that relates to another spreadsheet as follows

='S:\Folder level 1\Folder Level 2\Folder Level 3\[worksheet
name.xlsx]Page 1'!E6

Some of the final rows in the table do show a series of 0's

I have been looking at external links and importing data but cannot see
how this has been done or if there is a better way to do it.




--
ruthhicks999