I need help with macro: I have workbook containing many spreadsheets with
data format as follows:

2003.gada "08" Janvaris -- need get: 08-01-2003
2003.gada 12. Februaris -- need get: 12-02-2003 and so on
2003.gada "25." marta
2003.gada "22." aprilis
2003.gada "12." maijs
2003.gada "15." junijs
2003.gada 08. Julijs
2003.gada 05. Augusts
2003.gada "02." septembris
2003.gada "06." Oktobris
2003.gada "04." Novembris
2003.gada "01" Decembris

I need macro that will sequencely scan spreadsheets for specific data,
convert data into following format:

dd-mm-yyyy

then store it into separate spreadsheet (as list).

By default, data stored in F5 cell, but here is one small problem: some
spreadsheets formatting may differ a little, i.e. cells with data may be
differ(float from E5 to G5), for vertical also, for F4 - F6.
As you can see, Month name may differs in syntax a little also, be with or
without commas.