Allow me to share details about exporting customer data, T and T.
As you may have observed, only the default or current assigned Ship to address will be exported to Excel.
Additional details about exporting data to Excel are discussed here:
You'll want to keep track of the multiple yards outside of QuickBooks. Aside from that, you can also look for third-party apps that can help with your reports. You can find accredited and approved apps in this link: https://desktop.apps.com/home.
Let me know if you have other questions about managing clients and exporting data out of QuickBooks. We're always here to make sure they're all taken care of.