Repair Excel Roster Macro

I have an Excel file that’s meant to build a self-populating work roster, but the dashboard sheet is no longer talking to the roster grid. The Generate Roster button sits there looking pretty, yet nothing happens... (Budget: $250 - $750 AUD, Jobs: Data Analysis, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps)