Creating a Database with Data from different Worksheets

Hi everyone!
I'm pretty new to the excel world and I recently started to use this software to do some data analysis.

My problem is this: I want to create a database on a workbook with a list of orders but the data I have comes from different worksheets and I do not know how to creat such database without copying and pasting data.

I will explain my situation a bit better. I have 3 text files (.csv) with data about orderlines. Each text file is from a different region (Denmark, Sweden, Norway and Finland). The products sold in each country are the same, but of course the number of orders and the order ID differ for each country. I export each .csv file into an excel file and I have three excel files, DK, SW, NO and FI.

Now what I would like to do is to create a comprehensive order line workbook with data from all different countries. I would like not to copy and paste the data each time a new order arrive, at the same time I cannot just connect the workbook DK and SW for example in the same sheet in workbook 2 because then if I get for example another order from DK it would overlap the data below from SW.

I was thinking to create a pivot table, but I do not know how to do such pivot with data from different workbooks (and even though the headers are the same, there are different "order ID" numbers for each workbook), so I am open to any suggestion, really.

Is there anyway I can solve this problem?

Thanks in advance!

1 Today you create update 3 workbooks from 3 .csv files
- how often are the workbooks updated?
- how are they updated? (manually? by macro?). If using macro, please include it with your reply (wrap code tags around it)
2 Do you need to maintain 3 separate workbooks?
- how about 3 sheets in 1 workbook?
- or 1 sheet for all the records and using data filter to extract the information by country?
3 How many rows is the "all country" worksheet likely to contain now? And in 12 months?