Using VBA to copy and paste the content of multiple worksheets to a new files

[rugbyfitz]

sure did, just putting together the email now.
cheer for your help with this
regards
Nick