Hi there,

I'm quite new to VBA and only know some basic stuff.
Now I have a problem which I think can be solved with VBA, but I don't know how to do it.
I need to merge all the worksheets in Drawings.xlsx (sometimes more than 30 sheets) with my Title block.xlsx file and save it as a PDF in A3 format. (see PDF Template Example to see how it should look in the end for each sheet)
If possible I would like that excel counts the number of the sheet + total sheets in workbook Drawings.xlsx and that it adds this in the Title block.xlsx file in the highlighted cells so it appears on the PDF and will be different for each sheet.

Please find below a link to the files:
https://www.dropbox.com/sh/dn1zrrqq1...tkV7a-lZa?dl=0

If anyone could give me a start or point me in the right direction, that would be a big help!

Thanks,
Gillian