Importing data from one worksheet into another
 

I have an Excel worksheet in which I am tracking my inventory of items to
sell. I want to create a new worksheet that pulls only certain columns of
data from the existing worksheet. I want the new worksheet linked to the
existing worksheet so that as data is added, deleted, or changed, it is
reflected in the new worksheet.

In the new worksheet, I want to be able to create formulas using certain
data from the existing worksheet. I want to include ALL rows from the
existing worksheet (each row is ONE inventory item), but only some of the
columns of data. I hope this makes some sense, and that it is possible.

Thanks for your suggestions.