Hello everyone!

I am currently working for a sales division at large Company as a sales rep.
I would also like to add that I am not a CS person but a business person, so
please be patient!
What I need is this:
We're required to fill in a "one sheet" that displays sales data by
category, market share, etc (some other data) of a single store. Its a single
sheet, the problem is that I need to fill in 45 of them (45 stores), every
month (updating them).
In order to fill this I need to get shipments data, scanner sales data etc.
From different excel databases. There's a single reference value (store
number) that I could use to sort and arrange the data somehow. I was
wondering if I could do this using a macro or how?

I've seen excel files doing what I want to do, but I don't see they have a
macro, they might be using something else.

I'd appreciate greatly any help.

Thanks everyone!
Nathalie-Mexico City