Replacing Cells While Duplicating Range for N times

Hi Glenn. Sorry it was confusing.
I'll explain to you what I want to do completely.

1. My workplace is a retail chain with 70 outlets.
2. These outlets are sorted to what we call "clusters" according to their size to make it easy to handle a range of about 28,000 items.
3. XL cluster has 4 outlets, L has 10 outlets, M has 42 outlets, S has 2, XS has 5, XXS has 1 and there's one more cluster called 4K with 6 outlets.
4. We design layouts for the racks in each cluster at the head office, one per each cluster and send it to the supply chain WEEKLY to calculate the order quantities for each item. These documents are called "Shelf Stock Per Cluster"
5. We used to send them this information cluster-wise. Meaning, we send ONE file per cluster to the supply chain.
6. But to make this more transparent, I decided to send this information PER OUTLET. Which means instead of 7 files, one per each cluster, I need to be sending 70 separate files, one per each outlet.
7. For this, I must copy the information from each file, paste it to a new worksheet, once per outlet. But every time it gets pasted, the content of the "Cluster" column should get replaced with the outlet code. (IE: for XL cluster, the range should get duplicated 4 times. For L cluster, the range should get duplicated 10 times)

-----
That's the scenario.
Here's the specifics of the files.

1. The "Shelf Stock" file will ALWAYS have the following 10 columns.

Fixel_ID

Product_ID

Name

HOR_FACING

VER_FACING

DEP_FAC

SHELF STOCK

RANK

OUTLET

DISPLAY CATEGORY

2. The biggest of the 7 "Shelf Stock" files, which is the file for the "M" cluster, has around 2500 rows.
3. I need to be able to

• copy paste the content from ONE "Shelf Stock" file at a time within the "A:J" cell range, to the "Data" worksheet (Maximum of 2500 rows down)
• set the number of outlets in the "O1" cell,
• type in the outlet codes per cluster into column “L” (Maximum of 60 rows down)
• and get the result in the NEXT sheet which I named "Result"

4. Other sheets are only there for my understanding. I will be deleting them once the formula works.
Again, I thank you for trying to help me here.