Hi all, I just wanted to let you know that I've now managed to get this to work.
I can only assume that there must a typo because using the code above, except for creating the new workbook create the new sheets within, I can extract the correct source data.
Many thanks and kind regards
Bookmarks