Confusing spreadsheet
 

I have been tasked with trying to simplify a few spreadsheets that i use.
They are to track certain tasks that run, and then certain fields with the
output created.

I don't have much time to get it in place so i have found a few quick things
that may make life easier, but wanted some help in the code needed/best way
to make these changes.

1) Is there away to get multiple spreadsheets to update one main sheet?
There will be 5 seperate sheets for the different 'types' of runs, and then
one main sheet keeping track of run numbers, which will have 5 tabs for the
different runs. Is there a code which can cross refernce the type of run and
the tab name which should corrospond, and then fill in certain fields?

2) The five seperate sheets will have numerous tabs aswell so can this be
linked into the main sheet to fill in job numbers, as new tabs get created as
the runs happen, therefore there is no definate about the amount of runs
needed.