Generate Report

Greetings,

Basically, i need help hence why i am here.

How can i generate a monthly report from this file which will give me the following each month for EACH stock item:

Inventory Balance at the beginning of the month
Amount received for the month
Amount issued for the month
Inventory balance at the end of the month

I was thinking of creating another workbook for the report and link both but i do not know how to do such.

Please i need help!!!!

Thank you.