how to compare scores from survey completed weekly

I’m unclear on what you’re asking. Is it:

• When a user completes a survey, you want all their previous scores sent to you along with their new one?
• At a set time each week, you want a report of all users’ scores in aggregate?

If your objective is to look at scores weekly by respondent, I suggest a weekly dashboard delivery of a dashboard looking at week-over-week scores with respondents in the row and a weekly view on the columns (if doing a table) or x-axis (if doing a line graph).  If you’re looking at the respondent-level, I’m assuming it’s a small enough set for review. This will also allow you to look at who hasn’t responded.