I've been asked to develop a webform to look like a spreadsheet. Unfortunately, the site is written in D6 and I've only really developed in D7.
Can anyone recommend a module / method to achieve this?
It sounds like you're looking for Webform Table Element that will render your webform inside a table.
This module will add a new component to Webform module that allows you to render multiple components inside a table element.