Report stock movement report in excel 2007

Hi

I am sattar, working as Purchase Assistant in company.
I need your help to make STOCK MOVEMENT REPORT in Excel 2007.


Example:
I have tables in excel sheets.

Sheet 01 Purchases Table
Order Date
Order number
Part number
Item description
qty order

Sheets 02 Invoice Table
(Invoice Date
Invoice Number,
Customer Name,
Supplier Name,
P.O Number,
Invoice amount)

Sheet 03 Good Receipt table,
Good Receipt Date
Supplier name
Supplier date
Supplier Invoice number
part number
item description
qty received

Question:I need stock movement report on sheet 04 (extract all data from sheet 1,sheet 2 and sheet 3)
when I select any part number below should come full description of item with movement/history of the particular item.

when did this item come?
how much quantity we sold?
what is the invoice number?
how much quantity now balance??
what is the cost price?
what is the sale price?

Please advice and send me appropriate solution in excel 2007 Formula and function. (without programming)

Thanks in advance
S attar

Hey Sattar,

I'm about to head home so I can't help you out, but a few words of general advice.

1. Upload an example of your data, and what you want the output to look like
2. If this is a big job (and it sounds like it might be), you probably won't get it for free

That is all. Hopefully someone can help you out!