Getting info from one worksheet into another worksheet
 

Hi! I am setting up an inventory and order system for my business. I have
input into separate worksheets all the things we purchase, their costs etc.
I can input how many items I want to order and get a total order amount on
each separate worksheet. I want to be able to have each item I order from
each worksheet onto a new worksheet with the item ordered, the amount
ordered, the company ordered from, and the subtotal for each company so I
have a list of everything ordered and a total. Is it possible????

Thanks