Help reformatting block data into standard columns

I have a workbook with 26 worksheets full of address information in block format in 2 columns. Column A has the labels and column B has the data, looking something like the below:

Column A Column B
1.Name Acme Corp
Address 123 Main St
Phone # 555.867.5309

2.Name Widgets, Etc...
Address 1600 Pennsylvania Ave
Phone# 555.555.1212

I have about 100 addresses on each worksheet in the above format. I'd like to get all this information onto one page with column headers for name, address, phone, etc...

I can get the names into a list fairly easily using vlookup, because they have unique identifiers, 1.name, 2.name, 3.name, etc...but the rest of the labels in column 1 are not unique. Any thoughts on how to approach reformatting this workbook?

Thanks,
Dylan