Go through a named range and fetch results to new Sheet

[Sadsmileyface]

I have a spreadsheet with a Named Range of about 350 names, lets imagine it's in A1. B1 displays a value based on the selection in A1.

Is it possible to have Excel go through each name in A1, see what is shown in B1 and enter the values of A1 and B1 into a new Sheet?

(This is a simplified version of my actual spreadsheet, I know that in that example I could just look at the source data for A1 and B1. Just wondering if this is technically possible).