Selecting multiple sheets with defined ranges

Sheets("Sheet1").Range("A1:B29").ExportAsFixedFormat Type:=xlTypePDF, _

In sheet 1 the Range is -

Please Login or Register  to view this content.

I beleive I can use UNION function here -

Please Login or Register  to view this content.

but not sure how to use it in this code and if this is correct! How do I get something like -

Please Login or Register  to view this content.

Here it is, skipping the columns C:G as desired.

How do I get something like -

Worksheets((("Sheet1").Range("y of Sheet1")) And (("Sheet2").Range("A1.C15")) And (("Sheet3").Range("A1.D13"))). ExportAsFixedFormat Type:=xlTypePDF, _

Also, Sheet1 = Page 1 of PDF
Sheet 2 = Page 2 of PDF
Sheet 3 = Page 3 of PDF


Regards,
Anshul