Define Database. Are you talking about uploading the Excel spreadsheets to an
Access (or some other) database or were you wanting to create on big Excel
file. My preference for what you are trying to do is the Access Database
assuming that you are dealing with a relatively large number of records (
65,536). Once you have created the database (Access or Excel) then you can
just connect a pivot table to the data any your report should be very simple
from there.

This is a fairly big project. Are you familiar with
Databases such as Access?
ADODB Recordsets?
Pivot Tables?
Addins?

--
HTH...

Jim Thomlinson


"Marina Limeira" wrote:


I have 120 equal format files about hospital produces in cities.

example: group files.xls are territories files name

City item peoples
A item01 100

B item02 183
item03 432
Total
C item04 34


Are you send oppinion about I imagine create a big database with import from
120 files .xls
to analysing...

territory | city | item | people
1 A 01 100
1 B 02 183
1 B 03 432
....
3 A 01 343
3 A 02 433

Question, also example from VBA to import from several files.xls to big
centralize file database sheet ?

thanks for helping me

Marina