Consolidating Sales Data on Cloud from multiple Outlets in excel files

[skf786]

I would like multiple outlets to submit their weekly sales in excel files to a cloud location. this data would be in cells A2 to G2 in a file named Outlet code of each unit e.g. 0001.xls. These seven cells of each outlet i.e. A2 to G2 will be embedded in a main file placed on cloud in a sheet named 'TOTAL' e.g. data of 50 outlets will be saved in the sheet named 'TOTAL' from cells A2 to G51.Any help on how this can be done shall be appreciated.regards,Khalid