• I much prefer treating this requirement as a pull rather than a push. Make each query into a view, and give your user(s) select access to the view.

    Then create a workbook, and for each tab, install a "Data/Import External Data/New Database Query" to present the results of each view. Set the query data range properties to "refresh data on file open" (and other settings as you like.)

    The advantages:

    1. It is easier to implement

    2. The user always sees the most current query results

    3. To the user, there is no visible difference between a pre-populated workbook and one that gets populated when it is opened.

    (Just warn them that changes they try to make to the data by hand will be lost.)