page print set up multiple worksheets?

Afternoon folks. Hope you are all having a jovial day !

I am having trouble creating a code that perhaps one of you brilliant minds can help me with.

I am looking a code that will

> Fit to columns on one page for three sheets specific sheets (with specific names) while
> fitting to page the other two sheets

I've spent more time than i should (2hours) >,< and it always end with either something gets cut off, or it just doesn't work.

Attachment included

Explicitly, I am looking for
(sheets)
>"Data charts" to be fit to page
>"Pivot Table 1" to be fit to page and landscape mode
>"Extra statistics" & "Rawdata" & "Originaldata" to be fit all columns to one page

Note: The data volume changes each month so it is essentially that it doesn't just apply to this sheet but the fitting matches all future data sets! The goal is when I press the EXPORT PDF button, formatting won't be cut off the the sheets.

I appreciate any and all help! Thank you all!

Hi,
I know it is a bit late, but I searched and found this thread.
I need to do something almost exactly like what you asked regarding scale and print.
So did you solve the issue?