Thanks for all the help guys much appreciated. Customer has agreed to send in excel.
I have the headers and footers designed in Xara already, so will paste the columns from excel (pdf) into Xara.

Once again thanks to all for your time