VBA - Defining Variable Named Open Workbooks

All,

Thanks for the forum. I have found it very helpful, as I slowly learn some VBA. I want to know how to specifically define the names of open workbooks in VBA Code, from variable workbook names.

For example I have 4 excel books, opened in no particular order: Workbook, Dog, Cat, Elephant.

I want to define the workbooks Dog, Cat, Elephant, etc. so I can pull data from them and put it into the active workbook. The problem is that the names of the workbooks change everyday because the have the date in it.

Again, for example. The Dog Workbook would be "Dog 10 - Oct - 2013", but it always starts with "Dog", so I was wondering if there is a way to define the open workbook something like

Dog = workbooks("Dog*.XLS")

but everything I try, it doesn't work.

Thanks for any help.

Jeremy

Many Thanks Holger! Works great.

If InStr will come in very handy.

Cheers,

Jeremy