I have an additional problem

Range("Substrate1").AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Range( _
"A2:A3"), CopyToRange:=Range("AA5"), Unique:=False 'Filters and exports
Substrate1 data

Gives Gives "Application-defined or object-defined error

Dave Peterson wrote

If your code is behind a worksheet, then Range("S1") refers to the sheet with
that code--not the Substrate1 worksheet.

application.goto worksheets("substrate1").range("s1"), scroll:=true

should work
Oldjay wrote:

I have the following

Range("Z4:Z5").Select 'Copies blank cells to Country,CustomerPart NO &
Contacts Email input cell

Selection.Copy
Range("AD10").Select
Selection.PasteSpecial Paste:=xlPasteValues

Application.Goto Reference:="SubstrateStandard"
'This works where "SubstrateStandard" is cell Substrate1!S1

Sheets("Substrate1").Select
Range("S1").Select
'this will not work

Gives "Application-defined or object-defined error

oldjay