Well, you have not provided much detail with which I can be more specific.
Where does the data come from originally? Why is it in Excel.? Why is it on
ten separate worksheets? Is the format of the ten worksheets the same? Why
do you want to put it back into Excel when you mentioned something about
sending it to another application? Maybe you could skip Excel altogether.
Keep the data in a table in Access, set up the query, then export the data in
a format that can be used by your other application. Do you regularly append
data to the existing? Do you get a completely new set of data periodically?
So many questions!

Tom