I have 15 sheets which look something like this:
Name1 Desc1 Name2 Desc2 Name3 Desc3
chair a separate seat for one person, typically with a back and four legs. chair a separate seat for one person, typically with a back and four legs. chair the person in charge of a meeting or organization (used as a neutral alternative to chairman or chairwoman).
desk a piece of furniture with a flat or sloped surface and typically with drawers, at which one can read, write, or do other work. desk a position in an orchestra at which two players share a music stand. bookshelf a shelf on which books can be stored.
drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture. drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture. drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture.

I would like to be able to run a macro so all sheets look like:
Name1 Desc1 Name2 Desc2 Name3 Desc3
bookshelf a shelf on which books can be stored.
chair a separate seat for one person, typically with a back and four legs. chair a separate seat for one person, typically with a back and four legs. chair the person in charge of a meeting or organization (used as a neutral alternative to chairman or chairwoman).
desk a piece of furniture with a flat or sloped surface and typically with drawers, at which one can read, write, or do other work. desk a position in an orchestra at which two players share a music stand.
drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture. drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture. drawer a boxlike storage compartment without a lid, made to slide horizontally in and out of a desk, chest, or other piece of furniture.

Name1 is in A1. Essentially, the entries under the headings name1, name2, and name3 are sorted together. If an entry does not exist in all three, then the one it does not exist in is blank. The descriptions can vary, although the names are the same (such as how chair has two definitions). So, the definition under chair for one heading will be have to kept the same (i.e. not homogenized). Thanks for any help.