I would like to be able to search an entire worksheet for specific values and
when these values are found, copy them to a new worksheet. I have found some
examples here that were close, but not exactly what I needed to do.
I have a workbook that contains dozens of tabs with multiple columns of
alpha-numeric combinations. I want to be able to search the workbook for a
particular combination and when it is found, copy it to a new worksheet in a
single columnar list.
Example:
Sheet1 contains 5 columns A:E.
Each column contains alpha-numeric combinations like A1001234567,
B1001234567, C1001234567.
I would like to find A100* anywhere on Sheet1 and copy the cell that
contains it to worksheet A100. It doesn't have to be in any order and
duplicates are fine. I would just like them to be in one column.
Since I have so many tabs to go through, if it could search one tab, then
move to the next it would be GREAT. If not, I can run it on each tab.

Thanks for any assistance you can provide!