How to restore disappeared VBA Macros from Personal XLSB

Hi everyone, long story short, my computer was acting glitchy today so I restarted it. After, any workbook I tried to open would say it was "corrupt" and wouldn't open, or that it needed to be repaired. For the latter, it would say "Excel was able to open the file by repairing or removing unreadable content" which was usually sheets I had deleted from the file (so no real content missing?).

The big issue is my VBA macros are missing. I had saved all of them in my Personal XLSB. My Personal XLSB was also impacted by the issue above. It was after I repaired and saved the file that I noticed all the Macro modules are missing from the VBA editor (Alt+F11) and the macro dialog (F8). Macros are enabled in trust center, and there is no file history on the Personal XLSB. Of course I didn't back these up... :/

Interestingly, after repairing the Personal XLSB my other workbooks seem to open and run fine. No more popups stating the files are corrupt or need repair.

Does anyone know if it's possible to get the macros back? I am definitely no expert in excel or VBA so just hoping I don't have to rewrite them all...