|I can see why no one answered this. It looks like a stupid question because when I click on the highlighted (mapped) tags in the xmlmap the corresponding source cell is highlighted.|
BUT, the catch is that the sheet that was being mapped was hidden so I didn't know it was there. When I unhid the sheet, I can see what is mapped to each tag including macro values. It was a summary one line sheet of the main sheets using formulas to fill in the cell values.
To unhide sheets use home tab/format/unhide sheets and the hidden sheets will be listed.