Excel VBA Report

Looking to find a solution in excel ( VBA) to handle the following: 1. Create weekly, Monthly , year report of one location/ country/ region or consolidation 2. create new service categories and new account to generate the daily/ weekly/ monthly , yearly data 3. update new rates from start of the month or end of the month 4. consolidate all reports into one Process: 1. User will open the excel file ( VBA based) and select the following Region name ( to be added by Admin) location name country name account name to add revenue for the day. on click of submit - a user interface will open where user will be entering and save it. System will then ask user to add new account - if User says - yes then it will ask user to select another account and enter details and it continues until or unless all entries are made. If user - says no and few accounts revenue is not added then system will give error to user to complete the info. once this is done then user will be asked to enter the details such as 1. amount as per system report, POS collection amount, Money order details , Cash collection etc. ( this will be done per account) where as POS collection can be consolidated for all accounts. 2. on submit - system will check - if amount collected matches or not. if not then it will show all details 3. on validation - system crates report format as suggest in one sheet. In master file - another department will be entering deposits in the bank to review if revenue shared by office matches with the bank or not. discrepancies will be validated and shown in a report ( region/ location/ country/ account specific)