How can i get the filters in my sheets to work when i add macros 2 move between pages

I have been trying to add a macros assigned to message boxes to the bottom of each sheet that will allow the user to move between the pages but every time i apply the macros the filtering stops working.

As you can probably tell from the file I'm very new to macros and excel my formulaes are very simple.

Step 1 Agents Settings: message box activated once last cell is filled in, with option of "yes continue to next page", which will then open the input data page, while hiding the agents page, or "no I'd like to make some changes" returning them to the first cell to recheck and change data as needed. And then the same thing for remaining pages, input data, job breakdown, proposal page & foreman report

Basic idea is only being able to work on one page at a time till the last page, then all pages open but then i would like to deactivate the macros.

Any and all help would be greatly appreciated.