I think the password protection is not obstacle to combine files. all you want to combine data which can copy the data in read only mode.( as your file open read only mode without password).
I have created a macro with this basis...
Please check and like if it works.