How do I create a flow that appends different files into one on a schedule?

[Sertan_CPH]

Here I am again today with another version of the question I got answered yesterday.

Context:

I have a bill of materials (BOM) structure which is split into excel tables such as electronics, mechanical, accessories etc. 

Every table is in a different folder on sharepoint to be filled by a different person. Tables have the same exact columns. 

Can you show me how I can create a full BOM by appending above tables and making a new excel workbook, then save that workbook on a sharepoint folder then name it as File_ddmmyy  once a week? 

Thank you in advance!