How all.
I have a worksheet that I want to extract 7 characters from.
Below is a sample of the first few rows that I'd need to look at for the
specific locations.

------------------------------------------------------------------------------
"Truckee River Claim No. 303 (404) SUMMARY"

"Decreed Owner: OWNER's NAME successor to Prior Land Holder's Name"

Page No.: 35 & 44

Orr Ditch (303) Sullivan and Kelly Ditch (404) Acre Ft. cfs Acres

Map: TR-087
------------------------------------------------------------------------------------------

While this is just text, we generally work off of the first 6 columns
(pretty much std), the first two rows are merged, and this actually varies
from workbook to workbook.
What I want to extract would be the numbers- in this case, 303 and (404)
Sometimes this will be more-- about 10 occurrences of 10 + characters-- most
of the time it'll only be 3 characters.
My goal is to extract these numbers, and rename a worksheet (insert those
into the worksheet name) from
SUM (some variation of sum, summary, etc...) to Sum (some basic variation
thereof)-###, where the ### digits of interest.

I expect more questions, so go for it.
Thank you for your helps.
Best.