Excel VBA automated spreadsheet

I need to automatically populate an excel file with multiple sheets that takes information from other 2 sheets. The first sheet shall have buttons to execute files purpose: - update imported information - sorting and populating sheets - generating cvs file SHEET 1 (imported sheet) It has order information in detail, if an order has 5 items purchased, the info for the order will be repeated per product in that sheet in consecutive 5 rows, then the next consecutive order information. SHEET 2 (imported) it has order information by total of order, each order have 1 row even if the order has several items. Sheet 1 contains order information from the web-commerce and sheet 2 has information from payment-gateway. I need the excel file resulting to have a main home sheet featuring 1 or more buttons to do the processes I want: within a multiple sheet file to have: 1- the information drawn and updated in time from ecommerce sheet. 2- the information drawn and updated in time from payment gateway sheet 3- a sheet with all CONFIRMED orders in the ecommerce that are not present in payment gateway (fraud/hack preventing). 4- a sheet with all the CONFIRMED orders in the payment gateway sheet which DO NOT have an order CONFIRMED status in the ecommerce sheet (error preventing). 5- a sheet with all the detailed orders (ecommerce format) that are CONFIRMED in both sheets, ecommerce sheet contains multiple states, so we need to filter data. taking informatión from both sheets we populate another sheet. 6- a sheet with information from #5 sheet adapted to fill another sheet to be converted to CSV according to specific row order to be uploaded to information tool. the sorting for this sheet needs to be FECHA DE PAGO. THE IMPORTED INFO CHANGES EVERYDAY. THERE HAS TO BE A WAY TO EVERY DAY GENERATING A NEW FILE FOR EXPORT WITH THE PRIOR DAY INFORMATION, AND 1 WHERE ALL PRIOR SALES ARE INCLUDED IN A FILE. WE SHOULD HAVE ACCESS TO ALL CODE TO REVIEW AUDIT AND MOD.