I have created a file with 12 tabs – each tab contains the same list sorted alphabetically and contains different monthly information (revenue, stock on hand, margin etc.) which is hard coded by different departments every month.

Tab 1 has the master data and Items are all the time added to this master data list. At present, to update the other tabs when an item is added to the master data, I have to manually insert the items by inserting row in each tab to maintain the alphabetical order in all the tabs.

Is there any way whereby when an item is added to the master list in tab 1, the list in all tabs is automatically sorted alphabetically and corresponding data updated?