Sorting data

[jjchad]

Hi all, I'm trying to extract data out of excel into word that looks like the following format:


E205 4TH April 2012 11 nights Atlantic Isles

Southampton, Madeira, Tenerife, Gran Canaria, Lisbon, Vigo, Southampton



E20615th April 2012 9 nights Atlantic Coasts

Southampton Vigo Lisbon Cadiz Casablanca Gibraltar Southampton



E207 24th April 2012 12 nights Western Mediterranean

Southampton Barcelona Cannes Livorno Cartagena Gibraltar Southampton



E208 6th May 2012 7 nights Norwegian Fjords

Southampton Bergen Andalsnes Olden Stavanger Southampton



E209 13th May 2012 12 nights Atlantic Islands

Southampton Madeira Tenerife Gran Canaria Cadiz Lisbon Oporto Southampton



E210 25th May 2012 9 nights Atlantic Coasts

Southampton Gibraltar Casablanca Cadiz Lisbon Vigo Southampton

---------------------------------------------------
please see attached pic.

Is it possible to automate this task, i also have another 5 workbooks to do in the same format?

John