Create worksheet in masterfile and add content below existing content

[Hond70]

Context: each employee uses the same worksheet stored on a network drive to fill in their daily activities. I want to capture these activities into one masterfile.
I have found some very neat code to copy the content of a worksheet into a seperate masterfile.
Now I want to:
1. create a new sheet in the masterfile (if it doesn't exist) based on the value of cell B7 in the worksheet (a date)
2. in the new sheet of step 1, find the last row that is filled in, leave a row blank and then copy the content of the worksheet into that new sheet (e.g. in the workbook Tom presses CommandButton9 first and copies his activities to A1:M11 in the new sheet of the masterfile, then Frank presses CommandButton9 and copies his activities to A13:M23 etcetera)
How can I accomplish that?
See here for my workbook

Please Login or Register  to view this content.

This code should be integrated above to create a sheet if it doesn't exist

Please Login or Register  to view this content.

[Hond70]

I did it! Great! Thanks Google...

Please Login or Register  to view this content.