What I need to do is match subscriber phone number from one column and return
total for that subscriber to adjacent column for that subscriber searching
other worksheets in same book. What is the best function to use? Please be
specific as my Macro/VB are almost non-existing.

Main Worksheet:
Column A Column B
972-222-1111 (Blank)

Search
Worksheets with Data for several accounts (ws_acct1, ws_acct2,etc..)
Column A Column B
972-222-1111 $124.00

Main Worksheet: With Results
Column A Column B
972-222-1111 $124.00

Pretty staight forward, but have not worked with these functions in years.

Please help.