Hi Purnima,

You'll need VBA to automate this.. do you have any experience there?

I have an article at my site which can get you started if you do:
http://www.excelguru.ca/node/23

If you need help with it, let us know.

Cheers,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

Purnima Sharma wrote:
I have an Excel file that has ten tabs. Everyday I import data from ten
different queries from Access into these tabs by copy and paste method. Is
there any way of automating the transfer so that I don't have to manually do
it. It will not only save my time but will result in less errors also.
Thanks a lot!

Purnima Sharma