I have taken an existing SW macro from somewhere online and tweaked it a little to suit my needs. When you run the macro a window pops up that asks you to navigate to a folder. Once selected, every drawing file in the folder is opened one by one. A sheet format (specified in the macro) is then applied to every sheet in the drawing. The drawing is then saved and closed.

The only problem with this is that the scale of the drawing elements seems to revert to 1:1 every time, which I imagine is because of the highlighted text: