Move master list to separate workbook

Hi Everyone,

I'm trying to bring a project to my company but have no VBA skills (tried online courses but this old dog sadly can't learn new tricks). I have received tremendous help in the past and was hoping you guys could help out again.

I have a spreadsheet that does everything I need it to (Thnx Dflak), but I need to alter it slightly so that the daily register can be emailed/saved seperately without the other worksheets or the VBA code, especially the VBA code.

The ideal solution would be to have the Master list etc and the Daily register in seperate workbooks.

Thanks for any and all help given.

Regards

Sherman