Named Range Possible - Two worksheets

[MikeL]

There is 3 fields to fill in on Worksheet: Cells A1 to A3 . And customers put data in Cells B1 to B3.

FirstName:
LastName:
StateName:

I would like VBA to take the open worksheet and copy the data into Worksheet2 transposed from columns to rows.
I would also like to have named ranges so macro loops thru Worksheet 1 finds and appends.
Last fact is that Worksheet 1 can have different values and Worksheet 2 will be the summary of all entries.

Thanks in advance