I have more than 50 workbooks that I have to sort. I would like to add 2
sheets to each work book then copy the row that has a unique column in
common. The problem I am facing is all the workbooks have different names and
all of the worksheets have different names. Also the columns with the common
info varies from sheet to sheet.
I will try to give an example:
"workbook.xls" has 1 or more sheets named "tom", "cat", "435345", "&*^*^^",
and so on.
One column between A-ZZ will have these three choices of info "opened pep",
"opened step", or "closed".
I want a macros to add 2 sheets, name those 2 sheets "opened pep" & "opened
step"
Then search all other sheets for the same words and copy the entire row each
match is associated with and place the row in its perspective sheet.

CAN ANYONE HELP PLEASE!