I have a report done for me but the sheet names flip flop between "Migrated" or "Sheet 1" and "Non-Migrated" or "Sheet 2". So my macro breaks.

How do I set worksheet to have either name. I don't know if I have to do an array and if I do, how to use that other than just declaring the array.

Sub ED4NotepadFormat()

'On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False

Dim sht As Worksheet
Dim objListObj As ListObject

'Migrated - Sheet 1
Set sht = ActiveWorkbook.Worksheets("Non-Migrated") '''or sheet 1

'Non-Migrated - Sheet 2
Set wrksht = ActiveWorkbook.Worksheets("Migrated") '''or sheet 2
Dim lastrow As String
Dim ws As Worksheet