In excel I have several files in which there are areas where data is entered
on a regular basis. To save effort I would like to enter data in one file and
have it also enter into another file. Can I by using separate sheets in the
first file by combining the files and therefore have one lot of enteries?