VBA for print to pdf multiple sheets with different print ranges and save prompt

[sinkrswim]

I have to start by admitting that it's been a long time since I even attempted VBA and despite a few hours of trying different methods/blocks this week, I am still not getting the result I want, so I'm hoping someone can lend a hand.

I have a workbook shared by my team and I need them to be able to quickly print to pdf two of the 4 sheets (let's say they're called "Cost" and "Pricing").

"Cost" is a pre-formatted sheet with formulas lookup values from another sheet when data is entered into the first 4 visible columns, so there are about a page's worth of "blank" rows to allow them to enter the items they need to lookup.

"Pricing" is similar but uses some of the data looked up on Cost to calculate other things.

I want to set the print area to only the rows that have data on "Cost" and fit all columns to 1 page wide by 1 page tall. Mainly to avoid printing an unknown number of empty rows.
At the same time, I want to set the print area for "Pricing" to fit on 1x1 (not restricted by rows).
The filename should be based on the values in C2 - D2 - E2 on "Cost".
And the user should be prompted to select where to save the file.

Thanks in advance for any help!