Why dont you attach a sample file so we can help you with it?

Does the master file already exist? Or should i create a new one through the code? If you opt for creating it from code, each time you run the macro, a new one will be created.