I have a workbook with multiple worksheets and on each worksheet I would like to have a macro that saves that particular worksheet to a certain folder, and saves it as the data in a particular cell.

For example:
One worksheet is named "Tax40". I would like to save it as "A10" in Z:\SecDept\Recommendations

Any help would be appreciated!

-GorillaBoze