I haven't done anything special here, just spent 10mins sifting through whilst having coffee (my dear wife has me on 'Jobs round the house' today!)

I've removed the module with the functions in, they didn't seem to make any difference, so I'm assuming they were used when the frog was introduced and, once used, have done their job!

Put a userform progress in, not as quick as status bar but quick enough for this application, it's more visible to the user!

Removed the sheet selections during copy/paste.

It now runs in 17 seconds rather than 86!

If I get a bit more time then I'll have another look.

I couldn't upload the file here for some reason, I tried making it smaller by deleting the hidden sheets but it still wouldn't have it. Link to file here