Am copying multiple csv sheets from different folders into one worksheet.

folder1 folder2 folder3
1 csv 1csv 2csv

need to distinguish which sheet came from which folder when the data is combined.
so need to add a column in the end result sheet stating whether it came from folder1, folder2 or folder3

the data from folder1 will be at the top of the worksheet, the data from folder2 will come below , data from folder 3 will come below data of folder2..

data will be like so


name place thing from
hira india wood folder1
meera japan spoon folder1
lima Russia table folder2

please assist