I thought I'd use this opportunity to say hello and also to ask for advice. I used to program in Basic and Visual Basic ages ago but want to develop my knowledge and skills in VBA. The immediate problem I am trying to solve is as follows.

1) I have a number of Word documents that contain tables in a consistent format with the following column headings: Date; Action; Who by. These contain chronologies of the actions taken by different organisations in a case that I am reviewing

2) I want to merge these together into a combined table using the same format (i.e. columns headed Date; Action; Who by) in such a way that it also combines them into a single chronology. Hopefully the following will give some idea of what I want to do:

Chronology 1
DATE ACTION WHO BY
1/1/2020 Visit to client at 10.30am GP
3/1/2020 Repeat prescription written GP

Chronology 2
DATE ACTION WHO BY
1/1/2020 Visit to client at 2pm Social Services
5/1/2020 Telephone call to District Nurse Social Services

Merger of chronology 1 and 2

DATE ACTION WHO BY
1/1/2020 Visit to client at 10.30am GP
1/1/2020 Visit to client at 2pm Social Services
3/1/2020 Repeat prescription written GP
5/1/2020 Telephone call to District Nurse Social Services

3) Has anyone written any code that does something like this already? If so could anyone please point me in the right direction?

Many thanks in advance

Patrick