Hello,

I am wondering, is it somehow possible to create this:

I have a workbook with many worksheets and I need to pick certain area from every worksheet, copy it to new workbook - as values - and then create pdf for printing. So I would like to know if there is a chance to do it - probably with some macro - only by clicking to one button and if there is, could someone please guide me how to create it???

Thank you for any help!!!!

John.