My boss (who lies awake at night dreaming up these things) wants a workbook
in folder X which reads in the contents of all the (one sheet) workbooks in
sub-folders of X at the click of a button. Neither the sub-folder names nor
the names of the workbooks within them are constant.

I'm sure I'm not the only person who's had to do this and this is way beyond
my job description, so I'm writing in hope that if anyone has useful code
snippets, they'll post them.

Thanks in advance!
Sian