Adding & average calculating stock

Hi,


Q1- I want to add the 5-month stock & calculate the average stock. |I used consolidate feature in sheet 7 but "Item Description" & "Whse" field does not come in the field. Kindly tell me how to do that with consolidate feature & different function or which one will be easy. I gather all the data in 5 month inventory sheet.

Q2- After calculating the Average stock unit of different item, I have another sheet were I have to put it average unit value, how I can use index match in that sheet.