I have five Worksheets in a Workbook Four of them have the same formats and
are titled Week One, Week Two, Week Three and Week Four. Each of these four
have 30 Rows. The other is Titled "Performance Ratings" which also has the
30 rows, but with a different format. I need a VBA to connect the person's
"Name" Col E10:E40 in Worksheet Week One to the "Performance Ratings",
Worksheet Col C8:C38. W/S Week One is then sorted.

W/S Week Two only changes the Performance Points from C10:C40 to
"Performance Ratings" sheet Col G8:G38. Again this is sorted and the
accumulated points in the "Performance Ratings" is also sorted.

W/S's Week Three and Week Four are as above with the Performance Points
going to Col H8:H38 and Col I8:I38 respectively.

Again, after each of the 4 W/S's having been sorted, I need to sort the
"Performance Ratings" sheet.

Does anyone have a quick VBA for this? I have tried to link the four W/S's
to the Ratings Sheet but have failed. Maintaining the integrity of the names
with the scores after sorting is paramount.

Bob