Im creating a workbook that on one sheet will have about 25 columns of
information, and a row for each item. What I want my outcome to be is a
spreadsheet that mirrors the master, but is limited with the columns that is
in it. Basically, I want it to be a quick reference sheet to the master. Is
there a way to do this? I would be addiding and deleting things from the
"master" and would like the "reference" sheet to reflect the same
information, less a couple columns.

I work in the construction company, and the "master" sheet reflects all the
current jobs we have open, and contains the job name, start & completion
dates, location, engineer, crew, job type, job number, invoiced amount,
received amount, notes, etc.... Im wanting this "reference" sheet to have
just the job name, crew, start date, completion date and notes on it. Then
when I delete a job from the "master"(store it in another sheet), the
"reference" sheet will show the same thing.

It may sound confusing, but that is what Im needing. Any help that you
could give would be great. If there is a formula for this, Im just not sure
of the name. If someone could point me in the right direction, that would be
great :)

Thanks again for all the help.