Location Wise Inventory Report from Master Data of Inward & Outward

Hi,

Friends here i have attached a file which has Master Data of Inward & Outward List
In Inward Contains Opening(Named Prior 2012) as well as Inward(named 2012-2013) in Column "Y"
Outward contains my current year Outward

Now I want to Create a report in New workbook which will have All Worksheet for Inventory I have Set in Inward Column "K"
Say I have Inventory as Digital Basis, 2.4-3.9 DLP Cine HB Zoom Lens, Populated PCB -Interface Series
my new worksheet will have all this sheet name with my inventory name

then each Sheet will Give me a Report of Inventory Item

Which will have Date(C in Inward & E in Outward) Particular (Vendor Name & Bill To Name) Type( Purchase Type & Sales Type)
Invoice No., Qty Value, Purchase Value - Column T, Sale Value - Column R , Cost In front of Sales, And my Closing in

all This Must Based on My FIFO Working Cost will be there in front of each sales
The Report must contain Location wise Report Say I have 4 location, the 4 Worksheet will create like Branch Inventory Report
The Same will have A summary Sheet too in which i will get summary of all this Inventory Item with Location

Date Particular Invoice No. Qty Purchase Value Sales Value Cost Qty Closing Stock
1.4.12 Opening Stock 2 20000 2 20000
2.4.12 Christie 34567 10 534500 12 554500
5.5.12 PVR SEL/01/12-13 4 250000 73450 8 427600

Please Friends Help me

Even I have attached one Workbook has same code but I need to Put same in my file based on my criteria

Please see Copy5Code File