How can I have a master list of names on one sheet that reflects in
subsequent sheets and when coalated by row will coalate on subsequent sheets.

i.e.
first sheet is a column of project names & #s
subsequent sheets are "Residential Projects" "Commercial Projects" etc. w/
column headers for things like "sqaure footage", "total construction cost",
etc.

When I coalate the first sheet by name or # it's respective row on the
subsequent sheets coalates with it and vise versa.

Any suggestions would be appreciated.
--
kmr R A