Thanks for your quick response.
Ok, info as follows....
All relevant sheets exists i.e Main Database (source), Active, Non Active, Finance, Health.
The database is set as follows:
1 Active Public
2 Active Other
3 Active Other
4 Active Service
5 Active Service
6 Active IT
So anything which is active, regardless of sector goes to the Active sheet in the next available row.
Anything which is in the relevant sector goes to the sector sheet in the next available row, regardless of status.
The Status and Sector columns have drop down menus with preset details, so other details cannot be typed in.
Does this help?