Copy All Sheets and Paste Values To New Workbook

Hello All,

I think this should be easy, but I have scoured the internet and not found a workable solution. I have a worksheet named Test that I need to copy all sheets to a new worksheet called Final and paste Values only.

I will use this on 6 or 7 different worksheets with different numbers of sheets and different names.

I thought this would be super easy, but so far I have not found a workable solution. Any help is greatly appreciated.

Kelly