If I were you I wouldn't repeat job names in master sheet, so I suggest this
layout:

Master Worksheet1 Worksheet1
Accountant formula-
Bookkeeper ˇ
Finance
General

and the formula is this (job names and numbers being in columns A:B in
worksheets1,2,...):
=IF(ISERROR(VLOOKUP($A2,INDIRECT(C$1&"!A:B"),2,FAL SE)),"",VLOOKUP($A2,INDIRECT(C$1&"!A:B"),2,FALSE))

Fill it to the right and down as required!

Regards,
Stefi

€žLynda€� ezt Ã*rta:

I have a master sheet with about 50 different job descriptions, then I have
about 20 more worksheets that could have between 20 and maybe 40 job
descriptions with the number of people against them.
I want to put them all on the master sheet against the appropriate job
description but keeping them in columns against their appropriate worksheet
without having to go through and enter everything manually.

Master Sheet Worksheet1 Worksheet2
Accountant Accountant 40
Bookkeeper Bookkeeper 15 Bookkeeper 20
Finance Manager Finance Manager 12
General Clerk General Clerk 20

Etc.

I hope this all makes sense.
Thanks in advance
Lynda