Excel -Automate update of data fields

I havea somewhat large file with many rows of underlying data. On the HRIR tab is my source data with some dummy data to use. I need code to use this data to populate all the other data with the report form I would like to see. I DO NOT WANT formulas sitting in all the tabs. I want my report data to be created by code. The chart at the bottom of the “Reference” tab has rows that reference the values from previous week and previous month. I would like buttons for each table in the tab, individually, to be update with values from that data that I click the button. The type of automation I need is in the tabs “SOC 1- 3”, “SOC 4” and so on. I would like a button on the “SPOC” tab to update all of these tabs with the data form the HRIR Data tab. In the HRIR data tab, column BT has data that designate the Employee ID number of each resources manager. The total number of times a manager’s employee id number shows up in this column represents the number of employees that report to this particular manager. Entries pulled in to SOC 1-3 tab will be those managers who have 1 to 3 employees reporting to them. Entries that show up on SOC 4 tab are managers that have 4 employees reporting to them and so on. One thing to note is that I would like all new entries on each tab that show up to be highlighted at the top of the list. And a table with each leader’s numbers at that SOC level at the top of each tab. Summary data for all SOC 1 through 4 will be populated on SPOC tab. This is all to replace a series of PIVOT tables that are currently populating this file.