I am needing to create a macro that copies a range of cells from 2 different tabs in several different workbooks and creates 1 pdf file. I have 0 knowledge of VBA and don't know where to start. Any assistance would be great appreciated. This is done several times a week and really eats up time for the people that have to do it (which is not me). Why I am being tasked with creating the macro since it won't benefit me at all is a great question I do not have the answer to.