How to use VLOOKUP with mixed "look up_values" in multiples files and worksheets?

Dear All,

Once again I am here to ask for help. This time, it is a little more complex.

I need to import data, to a single file (number 01), from two differents daily files (they are always the same and come by email every day and could be salved .xls or .xlsx, I called them (02) and (03)); and other two files (they are filled out by hand, every day, one with data in three worksheets (04) and the other with only one worksheet (05), they are saved as .xlsx). I can work with all files open, it is not a problem.
=IFERROR(VLOOKUP(... did not work. I do not have a clue about VBA. I believe the solution involves ISERROR, IFERROR and VLOOKUP, but how? You will realize that the greatest difficulty is the mixed lookup values, cods and dates.

Please, help!

Best wishes,

Ricardo.