Auto-populate and sort data to a master worksheet from other sheets in a shared workbook

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.

Hi Naveed, Oeldere,

This is a shorter version of the workbook, I have entered a macro which populates the master sheet automatically when the data in th other sheets is altered however it doesn't sort them into alphabetical order which would be very useful.

HardDrive Index test 1.xlsm

Thankyou for your replies so far.

Gemma

Naveed,

That's great! Thanks so much for your help!

Gemma