The data  will be supplied to the form  by VBA.

It sounds as though you want VBA to get the data from the sheets (so that it
can put it in the form). This is normal VBA activity. Where are you having
trouble?