Generate Monthly Report

R/Sir
i am add new sheet name Monthly Report in this excel file than in monthly report sheet than i am choose September month & click on the Generate monthly report button than show Total Purchase
Stock, show total sale stock & show balance stock of September month total purchase stock data pickup from the the purchase sheet & total sale stock was pickup form the sheet2(1-9-2015), sheet3(1-10-2015),sheet4(2-10-2015), sheet6(3-10-2015) & than added sheet to sheet sale stock this was included to monthly report total sale stock please send the VBA macro code for generate monthly report thanking you sir i am send the attachments sir please see the attachments sir