Excel VBA Querying Access DB

My client has an MS Access database and wants to import 87 fields of data from it into an Excel worksheet. The only filter is the cycle number (an integer). Access field names are long so it needs multiple queries to get it all.

The twist: We presume we have dumb users, so we will provide each user with a workbook and when they open the workbook there should be only a button that brings up an input dialog box (for cycle number) so zero user training is needed. (Workbook is read only so theyare forced to do a SaveAs.) I have the VBA working fine for a single query but how can I code it to enter the cycle number just once for the multiple queries needed to collect all the data?