Hey guys, first post here. Just started working at a bank, and some help writing a macro that consolidates data from various worksheets into one. I've written it already and it works well:

Sub Consolidate()
Dim ws As Worksheet
For Each ws In Sheets
If ws.Name <> "Country Name" Then
ws.Range("A3:t64").Copy Destination:= _
Sheets("Country Name").Range("A" & Rows.Count). _
End(xlUp).Offset(1)
End If
Next ws
End Sub


The issue is that I want to only grab the values, not formulas. I understand that I should be using some variant of:

Selection.PasteSpecial Paste:=xlPasteValues


I just don't know how to actually integrate this into my previous macro. Any suggestions?

Thanks.