Macro function has been passed to me. not sure its exact function

I have been given the task of fixing a macro that has been written by somebody else.
The macro is supposed to search the worksheets within the wb for certain data types extract this information then transfer it to a table.
As it stands when I run the macro it appears to search through all the worksheets then does nothing.
I would greatly appreciate it if somebody could tell me what this macro is actually doing.
There is also a second macro which appears to do nothing at all.
Macro 1

Please Login or Register  to view this content.

Macro 2

Please Login or Register  to view this content.

Yeah that's what I thought. I don't really understand it either. Thanks for taking the time to get back to me.