Amalgamate Several Worksheets into one file thru Data import
 

I am having 12 files in different network locations. Each havinf one
worksheet inside. I just want to know whether I can create one file in my
hard drive and create 12 worksheets and Import External Data to each
worksheet from the different files so that I can see all of those worksheets
in indifferent network locations into one file. I tried the External Data
Import & Refresh but the command refreshes only the cells that contained data
at the time of setting up. New cells edited doesn't appear in my amalgamated
worskbook (also cells that contain formulas in the source files, when
imported are reflected as blank cells)
Anybody can help me on this? I just want to create a copy of all those
worsheets in my combined file when i open the combined workbook...
--
M Imran Buhary