Hi all,

I really appreciate it if someone will be able to help me with the following
problem.

I have a spreadsheet workbook with two worksheets that are all formatted
identical with three columns and different data.

I.e. (worksheet 1)
Year Car Color
1997 Holden Red
2000 Ford White

I.e. (worksheet 2)
Year Car Color
1998 Honda Blue
2004 Toyota Silver

I would like to be able to export the data to a word document when I press a
form button. For example ... when I press the form button, I would like the
word document to be formatted as:

Year Car Color
1997 Holden Red
2000 Ford White
1998 Honda Blue
2004 Toyota Silver

all the data from worksheet 1 followed by worksheet 2 but the headings only
appear the one time.

I hope that this is achievable.

Thank you in advance.