Cutom VBA in Excel to add interactivity

I have a functional spreadsheet which I want to add a dashboard - The charts will be added later and this work is to prepare for that by adding a new sheet which has some dropdowns to get some data and make some smaller tables from the main data set which will then be editable so as to update the main data set. There are 3 of these minor table sets to be made. The final workbook will need to run on the latest version of Office for Mac.