Excel help

We have an excel file with few tabs (sheets). Each sheet is listed on the Cover Page (sheet). We would select a few sheets by clicking a tick box from the cover page (sheet) and print them in pdf. We would like all the pdfs to be downloaded into the same folder where the main file is saved. Also, we require the file name to be in a specific format when printed in pdf. We are looking for someone with VBA skills to write code to achieve the above. Please quote for the same. Thank you.