Need to auto update data from columns to an excel to a different excel located on sharepoint

[nischal448]

Hi,

I need a solution to auto update data from columns to an excel to a different excel located on sharepoint. Both excel sheet similar column names where if data in column is updated in the masterfile , it automatically should update it on the other file, Both are located on MS365 sharpoint