How to transpose variable data from column B to multiple rows data is seperated by 2 blank

Hi, everyone, this is my first post although I have followed the forums guidance for years and many thanks to all the contributors.

I have a workbook with around 100 plus tabs, each tab is a separate construction trade with contact details, sample tab attached.

I am trying to create a list that would take the tab title as column A and transpose the Co Name & Address detail in column B into rows followed by the remaining data fields.

Addresses could be anything from 3 to 7 rows for each but each separated by 2 blank lines in column B.

I have tried various look ups and third party tools to try an achieve the desired result with many failures, hence my post in the hope someone may be able to help.

I have very little VBA experience apart from understanding how to copy code into macro and run, but I am willing to learn.

Many Thanks in anticipation.

Hi GWhite1956: I think I understand what you're after. However, Could you add another tab for one additional construction trade with some corresponding data, and an end result tab, which I'm assuming is a compilation of all the data from all the other tabs?

Pete

Hi thanks for the replies, it still amazes me that there are so many people out there willing to help. Attached an amended file with an output tab. The address in colum B in the trades tabs need split into several columns. Thanks