Hi, from what I understand, you want to do is read in data from multiple sources, combine the datasets, then generate a csv file. Is that correct? If so, that is possible.
There is no point telling us what your file location is as we don't have your data (or access to your folders). However, you can provide a reproducible example and that may help others to help you.