Export subform to Excel

[Katrina]

I have 2 forms, "summary" form and "detail" form.

Detail Form shows up as a sub form on Summary form.
What I would like to do is to (with the click of a button)
export all the information from Summary form and Detail
form that is showing for one "Reference" number.
(reference is a field)

In other words, I would like to export the one record from
Summary form and the linked data (more than one record)
from Detail form.

Is this possible?

Thanks for your help