I am tasked to do the following. It may sound abit complicated but I'll try my best to explain.

Let say I have a workbook with 3 worksheets, names 'A', 'B' and 'C'.

Spreadsheet 'C' is like a summary of A and B with numerical values and graphs.

Can I insert a button in A. At the click of it, information from A and specific information from C will be generated onto another new workbook and saved under a specific file name.

Same goes for worksheet 'B'.

Thank you in advance =)