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!