return all distinct unique values to another sheet if it exists in the other worksheets.

I have a workbook with a number of worksheets that hold staff profile data including name, area, positiion number, Staff ID, employment type etc. One sheet per area. for example each of the following areas have a separate sheet which holds data on all their staff:
head office
hardware
gardening
haberdashery
manchester

what I want is another sheet in the same workbook to list all staff we have, so if a staff ID number exists in either of the two possible columns containing staff IDs in each of the other sheets then it should be listed on a separate sheet once only, even if it exists twice throughout the whole workbook. the possible columns in each sheet have the same header i.e. 'Sub ID' and 'Act ID'

Each areas worksheet has picked up the staff ID numbers from another sheet within the same workbook using a forumula:

Please Login or Register  to view this content.

Thank you (first time poster, apologise if not clear).

This time with Attachment (Thank you FDibbins ) - please note I have modified heavily, there are many many more staff in the real one with more sheets as well.