Linking tabs and formulas based on input into cells

i need to link several tabs based on the input into one, which will give the output into the others

Profit Sheet tab, i will input the relevant information into here. From here, every job will follow through into Nigel's tab, which i have done, apart from the fact that there are cells with 0 in, which i think the formulas need updating. as you will be able to see, he receives 25% of the profit

within the profit tab i choose a certain "Fitter" from the dropdown menu, i then need the relevant details to follow through into that fitters tab and with them receiving 25% of the profit aswell

hope this has explained it

thanks

anybody help please?