I want a better solution

I wrote this football pool program which autoemails everyone in the pool sheets for them to put their picks on. They then email it back (saving the file as unique name so the program can automatically pick it up). The problem is:
a) The person in charge of the pool has to take each email (from 30 ppl) and store the attached sheet in a special location.
b) People keep changing the file name, which means that the main program, when compiling the picks into a master document, "doesnt find it".

I thought about adding an 'email back' button on each personal picks sheet, but then they have to toy with enabling macros and setting security levels (which i dont want to do for them)

Any thoughts for a better solution? Thanks!

I've done something similar.

For a) I automated Outlook from Excel, saving the email attachments to a folder, see http://www.*****-clicks.com/Excel.htm
The answer to b) is not to rely on each sheet having an exact name. I used FileSystemObject To process all Excel files in a folder, see code snippet:
(Set a reference to Microsoft Scripting Runtime to use FSO)

Sub ProcessSheets()
Dim oFSO as New FileSystemObject
dim sFolder as String
dim oFolder as Object, oFile as Object, oFiles as Object
dim sceWB as Workbook

sFolder = ThisWorkbook.Path & "\"

Set oFolder = oFSO.GetFolder(sFolder)
Set oFiles = oFolder.Files

For Each oFile in oFiles
If oFile.Type = "Microsoft Excel Worksheet" Then
Set sceWB = Workbooks.Open(FileName:=oFile.Path)		'open workbook
'Copy stuff to master workbook here
sceWB.Close
End If
Next oFile

Set oFolder = Nothing
Set oFile = Nothing
Set oFiles = Nothing

End Sub