Why are you re-entering information? Can't you just copy the sheet you need, delete the unwanted fields, and filter the data you want? You could write a simple macro to automate it if that suits you.

I work in a prison and I deal with a lot of inmate files. I manage their work schedules, time, religious diets, allergies, etc... I would like to be able to create a master sheet for a particular area, diets and allergies let's say. Then I would like to be able to create other sheets that read from and are based off of the master sheet. For instance, I might want to divide the sheets by the units they are in for example, so for all inmates that live in units 1-10 the prison staff would have sheets that contain all the inmates in units 1-10 and for all inmates in units 11-20 I could have another sheet with those inmates for the staff in that particular area. But the additional sheets would be automatically built based on the value of a given column that I could add/remove inmates from one sheet or file and have it carry over to the other derived sheets / files. Is this something that a macro would be good at? I've never dealt with macros in any shape form or fashion and outside of a little C++ tinkering I've never really heard of them. Thanks.