We receive a spreadsheet with multiple tabs from a vendor. Within each sheet
there are multiple items and totals with extended costs. I need to extract
the amount and acct number on only the rows that have 'Total.' For example:

Type Extended
1234 30.00
1234-ab 8.95
1234-abc total 38.95

In this example I want to only extract 1234-abc in one column and 38.95 in
another column. And do this for each tab.

Can anyone suggest the best way to accomplish this task?