Macro to copy sheet(s) and paste as values only

Hi all,

I am looking for a macro that will copy a worksheet to a new workbook and 'paste as values only' - this is because I already have a macro that I am trying to use to 'autofilter' the sheet to only show rows and colums that have entries in them. Since the sheet is dynamic, the macro will not work unless I copy and paste as values only...

Workbook attached - FYI, the 2 sheets in the workbook are actually in 2 separate books, I have just put them together to make it easier to post here...

TIA!

Is this what you mean?

Option Explicit

Sub CopyValues()
'copy sheet to new workbook
    ActiveSheet.Copy
    'convert to values
    With ActiveSheet.UsedRange
        .Value = .Value
    End With
End Sub