Hi,
I need macro that will Convert sheets to pdf in which Filename and location path are based on a cell.

Sheet names: UserPage and Summary_Print
Filename: UserPage!A1
Location: UserPage!A2

Thanks so much.