COPY EXCEL COLUMN DATA FROM ONE SHEET TO ANOTHER

COPY EXCEL COLUMN DATA FROM ONE SHEET TO ANOTHER

I am trying to build a workbook to track my personnel & their training. I
have a master worksheets which i will be editing and subsequent worksheets
which will pull data from the master sheet to provide me with the data i
need (i am trying to avoid making an Access Database, so excel only
please). The trick is, if i add another row (new member) or delete a row
from the master worksheets, I want it to automatically do the same on the
other worksheet. Is this possible, and if so, how do i do it? thank you.