Combine data from two sheets to one or create new sheet

Originally Posted by endlyss

Is it possible to do calculations using data from one sheet on another completely different sheet?

I would like to make a sheet that sums up data from another sheet(s).

I'm not finding out from the material that I have on the subject.

Thank you.

Richard

I have two sheets, aged inventory and sales data. Product numbers are the same, i just want to create a table for both sheets or a new new sheet that would list the inventory and sales but i only need sales infor for the items in inventory.

I just want sales for items in aged inventory.

Thoughts, ideas or comments well appreciated.