Tracking Cost Price from Different Sheets
 

Sir,
I have Three Worksheets of PaintingStock, JewelleryStock and TextileStock.
It have particular
ID No. of particular item.

I report daily to my boss that what is item number sold from the above
mentioned stock and
what was the cost price.

How i can track in one seperate sheet its actual cost price using ID No. of.

All Sheets have columns in this manner

A B C D
ID No. ITem Name Cost Price Sale price

and My Daily Sales report format is in this manner

A B C D
ID No. Name of Item Cost Price Sale Price

I want to track cost price in column C using a formula which u will be
suggest.

thank and regard

RRS