Workbook automation for values

[knoja31]

So I have a workbook that i would like to automate some functions on open.
The workbook has two sheets (members & positions).

On the Members sheet it has:
their name (column A)
Phone number(column B)
Email (column C)
Date they joined (column D)
Positions held (column E)

On th ePositions sheet it has:
Position (column A)
Member holding that position (column B)
Length of term (column C)
Start date (column D)
End date (column E)
Comments (column F)

The start and end dates are based on the second Wednesday of the month.

Item 1:
I would like to have a function (preferably vb) that for the member sheet it would do a lookup on the position sheet, find every instance of a members name in column B and return all positions held into column E of the members sheet separated by a comma.
I would like it so that it does this without having formulas on the sheet. That way when the next person takes over, they do not accidentally delete a complex formula.

Side note- nothing is in ascending order. Also, members and position can be added and/or deleted from either sheet.

The other items I might be able to figure out but this is the one that is kicking my hiney!!!!

Thank you in advance!!!!

[arlu1201]

Why dont you attach a sample file with some dummy data?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[knoja31]

Here is a sample of the file. Some of the information that i stated is a little off. Was trying to remember what columns there were.