Many Sheets, One DB

[lewashby]

I deal with a lot of Excel files on a daily basis and I need some help. I may have 8 fields (columns) in one file or sheet, let's say file/sheet A, but I may need some of the same data (rows) in another file/sheet, let's say file/sheet B, but maybe only using five of the original fields in file/sheet A and maybe only rows where field ABC = XYZ. I'm currently having to edit more than one file or sheet with mostly the same information on a daily basis and I know there's got to be a better way. Each time I enter the same information I'm giving myself the opportunity to make a mistake, I'd like to be able to insert, drop, and edit changes in one file or sheet and have the other files/sheets act as little more than displays for the main data sheet. I think the current version of Excel I'm using is a little dated, 2010 I think but I'm not sure. If you have a solution please let me know even if it will only works in new version as I might be able to get my employer's IT supervisor to upgrade my Office edition. Thanks for any and all replies.