How can i create a master sheet from separate sheets?

Options

i want to create a masters sheet for a general over view of projects in the pipe line

Sheet 1. Sales this will have customer info, size of job and a fee key points of the project

sheet 2. project management, who is contracted what we need to traack

sheet 3 owner billing

sheet 4 sub billing

master sheet would take job (rows) info from each sheet to create a master sheet of perinate information but not all columns as to not cloud the viewer with data.

i would like the master sheet to be a live linking sheet where if sheet 1 adds a job its added to the master or all other sheet

Answers