Staff vacation days

[danman2003]

I need to make a spreadsheet which shows the vacation days of the staff at the office in a monthly view.

The one I set up is modelled on this

I assumed that all the manager would do is just add staff to the list to column A of the first sheet. So I made a simple cell refence in the first column of each month that would mimic the staff list in sheet one. However, she wants to be able to reorder the names on the staff list, and have all rows of every month/sheet follow the change.

Any help would be greatly appreciated.