Add Features to a Macro Enabled Spreadsheet

I have a Macros enabled spreadsheet that I import sales data into, which then works out profit on all sales (via page where I enter cost values to SKU's). I would like this spreadsheet edited to be able to accomodate a few extra features. I would like the spreadsheet to be able to give me an overview of sales for the week/month/quarter/year, I would like it to automaticlly generate data of best selling product/biggest profit items etc. I would also like to incorporate a stock control element, so I can enter when I buy stock, and it is deducted from the stock as and when it sells (through the use of SKU's) and then this data collated on a weekly, monthly basis to show how much stock is being used on a weekly/monthly basis which will enable me to see trends and also and easy way to see when we are running low on stock. Best Regards, Ben