This is how you refer to a cell in another cell
='[My Second File.xls]Sheet1'!$A$1
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"Roger on Excel" wrote in message
...
I have a spreadsheet with information stored on Sheets named St1, St2 and
St3
The spreadsheet retrieves data from specific cells on the sheets and
gathers
them on a summary sheet.
What I would like to do is be able to import St1, St2 and St3 from other
similar spreadsheets so that my spreadsheet can summarize these data sets.
So, I am asking if there is a way to import specific sheets from another
spreadsheet
I would also like to know if there is a way to export changed sheets to
save
them as a new workbook? or better still update the spreadsheet from where
the
sheets were imported from
Can anyone help