It seems from your description that you have a substantial database with
multiple users who want different reports from the database. I would not be
using Excel for this. Access will handle it more effectively, and allow you
to have concurrent users.

Even if I was just doing the job  you are talking about I would put the data
into Access.