VBA to Refresh, Select Multiple Sheets, & Print To PDFs

[ExcelAtEverything]

Hello!

I have a workbook with 30-ish sheets, of which I would like to have code which will ultimately print (to PDF) the same 10 sheets each day, after completing a couple of other tasks as well.
Specifically, this is what I need it to do:

1) "Refresh All" queries, data model, and pivot tables in the workbook (Workbook name: "Workbook1".
2) Select & print 13 sheets to PDF. (These will be the same sheets each day & the sheet names never change, unless I happen to add more at some time in the future).
To save keystrokes here, let's just say it's 3 sheets, which are called "Sheet1", "Sheet2", "Sheet3".
I would like the names to be a combination of the sheet name and today's date. So today, they would be called "Sheet1 7/4/2021",etc.
3) Resave workbook.

Thanks.

 

[ExcelAtEverything]

This thread can be deleted. I figured it out, but I'm also changing the way I'm doing it So I'll likely ask some different questions in another thread.