I forgot it was Wednesday
. Everything shuts down at lunchtime on a Wednesday here, which put paid to my shopping expedition, so I spent a few minutes adding a date selection to the userform.
The damage I have discovered so far is a lot less than it might have been. An electric kettle was fried. A few fuses blew. My satellite TV boxes are fried and the internet was taken out, but because the surge protector did its job, there was no damage to the PC, and the telecoms company have checked out their modem and that too is OK. I can live without satellite TV, thanks to the internet.
The function which reads the worksheet names doesn't like spaces in the names, as yoiu have discovered. It is easy enough for you to change the space for an underscore before using the function.