VBA formula query based on a text for surch of a tab

[SJO]

Hello, first please excuse my ignorance I am a beginner!
I’ve used the automatic recording VBA process, but I would like to add a true condition on a text in cell to search a tab name in another file. How can I add this formula? Many thanks

Sub MacroTEST1()
'
' MacroTEST1 Macro
'

'
Windows("EPCR_Mastercard report SJO 20_21.xlsx").Activate
Workbooks.Open Filename:= _
"C:\Users\UserName\Documents\Mastercard\TEST\EPCR_Mastercard report SJO 20_21.xlsx"
Range("A12:D41").Select
Selection.Copy
Windows("New MatserCard_global_TEST.xlsm").Activate
Sheets("SJO").Select
Range("A12").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
Sheets("Synthèse").Select
ActiveWorkbook.Save
End Sub

 

[Wookiee]

Can you give an example of text you'd like to search for and the context in which you would use that to search in a different workbook?