VBA Set .Worksheets name wildcard

[VETROVJ]

Hi all,
I found a great macro to combine different works sheets but my issues is that the sheet name change from file to file. How could I change this line

Set wksSrc = wbkSrc.Worksheets("data"[FONT=Consolas, Liberation Mono, Menlo, Courier, monospace])

[/FONT][FONT=Consolas, Liberation Mono, Menlo, Courier, monospace]to something like this

[/FONT]Set wksSrc = wbkSrc.Worksheets("*"[FONT=Consolas, Liberation Mono, Menlo, Courier, monospace])

[/FONT][FONT=Consolas, Liberation Mono, Menlo, Courier, monospace]The link to the macro is here
[/FONT][FONT=Consolas, Liberation Mono, Menlo, Courier, monospace]https://danwagner.co/how-to-combine-multiple-excel-workbooks-into-one-worksheet-with-vba/

[/FONT]Many thanks for your help

 

[MARK858]

Use the worksheets Index number. See the link below for the different ways to reference worksheets.

https://www.ozgrid.com/VBA/excel-vba-sheet-names.htm

 

[Norie]

You can't use a wildcard directly for this.

Is there any way you can identify the worksheet(s) you are interested in?

 

[VETROVJ]

Use the worksheets Index number. See the link below for the different ways to reference worksheets.

https://www.ozgrid.com/VBA/excel-vba-sheet-names.htm

The issue is that the sheet number could be different from one to another. So I cannot use the Index number

 

[VETROVJ]

You can't use a wildcard directly for this.

Is there any way you can identify the worksheet(s) you are interested in?

The name changes because Im combining CSV file where the sheet name change based on the file name.

 

[Fluff]

A csv file only has one sheet so you can use the index number