I have never really used VBA and so am completely stuck at this problem. I need to create a macro which auto-populates a master worksheet from the individual sheets in a shared workbook and then automatically sort the combined data alphabetically.

Sheet 1 is the master sheet . There will be an undetermined number of individual worksheets.

Each worksheet will be identical, using columns A-F with row 1 having headings included.

There will be a varying number of rows in each of the individual sheets.

If possible I would like the macro to run every time data is entered into one of the individual worksheets and sort the combined data in the 'Master Sheet' alphabetically from A - Z.

If anyone can help it would be much appreciated.