Hello everyone,

I'm having some big problems and I could really use help. I know very
little about Excel macros, which is why I'm here.

We used to have a macro, or so I'm told, that would do what I'm trying
to get done, but we have a new computer at work and don't have this
macro anymore. If someone could help me out, it would be a huge
relief.

We have workbooks full of information, and within the workbook there
are multiple tabs. Within those tabs are blocks of information. What I
want to have is on the first, empty tab, I want to put in a person's
name and then the macro searches through the workbook and pulls out
all of the blocks of information and shows them on that first tab.

All of the blocks of information are seperated by spaces.

Can anybody help??

Thank you so much.