MS Excel - multiple worksheets, same data question?

[step10solutions]

Hello,

I have a problem which is mind boggling to me. I know it can be done, I just don't know how to go about getting this done and was wondering if someone could offer some possible solutions or ideas?

Okay, I have excel spreadsheets (employee info), that is updated on a monthly basis, let me back up, I receive a new one from the person that generates the spreadsheets on a monthly basis and am trying to get away from having 100 spreadsheets, but just track the info as it changes.

On the spreadsheets, all columns are the same (just row data is different according to the individual employee), however; when a new spreadsheet is sent, a new row (employee) may have been added or info in that row may have change like employee status.

How could i create an ongoing tracker to possibly import a spreadsheet, with it just updating and highlighting the changes, but not have 100 spreadsheets to look for, better yet keep up with, so I don't clutter my computer?

Let me know if I need to reword this.

Thank you.

[TIPPYS]

There are ad-ins that can help with this that would probably cost money, or there is the compare and merge workbooks under the tools menu. However the compare and merge workbooks has some limitations. The workbooks must be shared (i.e. track changes must be turned on) and I think that it must be a copy of the original file. That means you may need the person who "feeds" you the updated workbook to be on board with it. You may want to look at these links.

http://www.ehow.com/how_2020064_merg...oks-excel.html

http://office.microsoft.com/en-us/ex...CH010003671033

http://office.microsoft.com/en-us/ex...771691033.aspx