Spreadsheet: 670126d1585758788-finding-data-across-multiple-sheets-with-highlighted-answers-excel-sample
Sheet: Old Master

 | MO | Beam | Quantity
 | 97L0008787 | WP01015N10300 | 2968
 | 97L0009072 | WP01015N10300 | 3816
 | 97L0008932
 | 97L0008936
 | 97L0008933 | WP01015N10300 | 6501.33
 | 97L0008934 | WP01015N10300 | 890.4
 | 97L0008935 | WP01015N10300 | 2261.33
 | 97L0008890 | WP01015N10300 | 8480
 | 97L0009010 | WP01015N10300 | 3816
 | 97L0008931
 | 97L0008987 | WP01015N10300 | 610.56
 | 97L0009006 | WP01015N10300 | 7021.44
 | 97L0009025
 | 97L0008982
 | 97L0009091
 | 97L0009026
 | 97L0009059
 | 97L0009060
 | 97L0009061
 | 97L0009062
 | 97L0009009
 | 97L0009058
 | 97L0009068
 | 97L0009074
 | 97L0009075
 | 97L0009076
 | 97L0009077
 | 97L0009078
 | 97L0008965
 | 97L0008519
 | 97L0009145
 | 97L0009146
 | 97L0009092
 | 97L0009093
 | 97L0008966
 | 97L0008520
 | 97L0008967
 | 97L0008521
 | 97L0009134 | WP01015N10300 | 424
 | 97L0009135 | WP01015N10300 | 424
 | 97L0009136 | WP01015N10300 | 424
 | 97L0009144 | WP01015N10300 | 7716.8
 | 97L0009049 | WP01015N10300 | 5266.08
 | 97L0008735 | WP01015N10300 | 7632
 | 97L0008817 | WP01015N10300 | 110240
 | 97L0008947 | WP01015N10300 | 12974.4
 | 97L0009086 | WP01015N10300 | 15798.24
 | 97L0008585 | WP01015N10300 | 2060.64
 | 97L0008866
 | 97L0008893
 | 97L0008945
 | 97L0008946
 | 97L0008954
 | 97L0009067
 | 97L0009048
 | 97L0009139
 | 97L0009141
 | 97L0009140
 | [NAME]
 | 97L0008963 | WP01015N10300 | 4100
 | 97L0008911 | WP01015N10300 | 34344
 | 97L0008950 | WP01015N10300 | 9735.04
 | 97L0007928 | TRIAL N/A
 | 97L0008892 | WP01015N10300 | 3300
 | 97L0008698 | WP01015N10300 | 21200
 | 97L0008646 | WP01015N10300 | 38584
 | 97L0008964 | WP01015N10300 | 4409.6
 | 97L0008577 | WP01015N10300 | 17172
 | 97L0008713 | WP01015N10300 | 23744
 | 97L0008852 | WP01015N10300 | 12296
 | 97L0008869 | WP01015N10300 | 20352
 | 97L0008872 | WP01015N10300 | 13568
 | 97L0008871 | WP01015N10300 | 10176
 | 97L0008714
 | 97L0008715
 | 97L0008870
 | 97L0008731
 | 97L0008834
 | 97L0008895
 | 97L0008848
 | 97L0008951
 | 97L0008855
 | 97L0008865
 | 97L0009018
 | 97L0009038
 | 97L0008874
 | 97L0009044
 | 97L0009039
 | 97L0009040
 | 97L0009041
 | 97L0008873
 | 97L0008451
 | 97L0009037
 | 97L0008452
 | 97L0009111
 | 97L0008983
 | 97L0009046
 | 97L0009105
 | 97L0008806
 | 97L0009047
 | 97L0009064
 | 97L0009112
 | 97L0009083
 | 97L0009142
 | 97L0008583 | WP01015N10300 | 7776.16
 | 97L0008743 | WP01015N10300 | 10176
 | 97L0008849 | WP01015N10300 | 4011.04
 | 97L0008853 | WP01015N10300 | 8649.6
 | 97L0008910 | WP01015N10300 | 11872
 | 97L0008998 | WP01015N10300 | 11872
 | 97L0008783 | WP01015N10300 | 20352
 | 97L0008481 | WP01020N10300 | 11153.7
 |  | WP01004N10300 | 9271.8
 | 97L0008780 | WP01015N10300 | 18282.88
 |  | WP01265N10300 | 14854.84
 | 97L0008816 | WP01015N10300 | 2544
 | 97L0008854 | WP01015N10300 | 4579.2
 | 97L0008981 | WP01015N10300
 | 97L0008980 | WP01015N10300 | 7632
 | 97L0008819 | WP01015N10300 | 4028
 | 97L0008949 | WP01015N10300 | 9328
 | 97L0009027 | WP01015N10300 | 4367.2
 | 97L0008389 | NA | 4367.2
 | 97L0008631 | WP01007N10303
 | 97L0009084 | WP01007N10303 | 8564.8
 | 97L0009055 | TRIAL | 16101.82
 | 97L0008810 | TRIAL
 | 97L0009069 | WP01015N10300
 |  | WP01265N10300 | 31342.08
 | 97L0008632 | WP01020N10300 | 25465.44
 |  | WP01004N10300 | 12973.1
 | 97L0008633 | WP01020N10300 | 15606.26
 |  | WP01004N10300 | 12973.1
 | 97L0009119 |  | 15606.26
 | 97L0008390
 | 97L0008720
 | 97L0008721
 | 97L0008391
 | 97L0009132 | [NAME] | 4828.8
 | 97L0008218 | WP52574Y10380 | 7784.64
 | 97L0008217 | WP52574Y10380 | 5189.76
 | 97L0009023 | NA - trial
 | 97L0008610 | NA - trial
 | 97L0008302 | WP52574Y10380 | 5189.76
 | 97L0008303 | WP52574Y10380 | 5189.76
 | 97L0008680 | WP01015N10300 | 551.2
 | 97L0008839 | WP01004N10300 | 8056
 | 97L0008880 | WP01007N10303 | 1272
 | 97L0008909 | WP01007N10303 | 3816
 | 97L0008885 | WP01015N10300 | 8904
 | 97L0009143 | WP01015N10300 | 3816
 | 97L0009024
 | 97L0009028
 | 97L0009033
 | 97L0009106
 | 97L0008393
 | 97L0009063
 | 97L0008392
 | 97L0009056
 | 97L0008394
 | 97L0008395
 | 97L0008588
 | 97L0008784 | WP01015N10300 | 250000
 | 97L0008831 | WP01015N10300 | 435024
 | 97L0009113 | WP01015N10300 | 20809.92
 | 97L0008832 | WP01015N10300 | 188892
 |  | WP01018N10050 | 188892
 | 97L0009070
 | 97L0009071
 | 97L0009097
 | 97L0009098
 | 97L0008805 | WP01020N10300 | 20000
 | 97L0009030 | WP01020N10300 | 3478.5
 | 97L0009034 | WP01015N10300 | 5189.76
 |  | WP01015N10300 | 5189.76
 | 97L0008941 | [NAME] | 18206.56
 | 97L0008862 | WP01004N10300 | 30528
 |  | WP01004N10300 | 30528
 | 97L0009029 | WP01020N10300 | 18937.32
 |  | WP01020N10300 | 18937.32
 | 97L0009043 | WP01015N10300 | 41213.18
 | 97L0009090
 | 97L0009050
 | 97L0008979
 | 97L0009017
 | 97L0009073
 | 97L0008410
 | 97L0008383
 | 97L0008384
 | 97L0008984 | [NAME] | 15497.2
 | 97L0008906 | WP01047N10385 | 2890.33
 | 97L0008961 | WP01047N10385 | 10570.11
 | 97L0008962 | WP01047N10385 | 5397.5
 | 97L0008956 | [NAME] | 30782.4
 | 97L0008943 |  | na
 | 97L0009079 | WP01047N10385 | 13339.44
 | 97L0008985 | [NAME] | 14416
 | 97L0008958 | [NAME] | 58999.6
 | 97L0008944 |  | na
 | 97L0008836 |  | na
 | 97L0009101
 | 97L0009100
 | 97L0009117
 | 97L0008837
 | 97L0009116
 | 97L0009115