While writing a macro to harvest data from Word documents is not difficult (see, for example: https://www.msofficeforums.com/word-...tml#post121223 & https://www.msofficeforums.com/word-...tml#post120046), without knowing what columns the data you want are in and whether it's those cells that might be merged, writing that part of the macro is reduced to guesswork. Surely you could provide a document showing just those parts of the tables from which the 'Age' data are required; no-one's privacy would be compromised by that!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]