Hello,

I'm at an early stage of designing a spreadsheet that will be used by staff
to enter their expenses. My aim is that a user enters information into the
file, sends to an administrator who consolidates the company picture.

I can get the user input to appear in the same cells in each file but need a
method centrally to read or open the file, store specific detail into
another spreadsheet file from which we can work on, all this needs to happen
with little intervention from the administrator. There will be about 100
files per week and the consolidation needs to be on those with a certain
weekending date.

I've seen something in Lotus that looked in a closed file and read the
contents of the cell but can't get the same to happen in Excel.

Any help greatly appreciated.