If you want to "click a button" and use a "list box on a userform", then you would need to use a macro for that.

However, you could achieve this using formulae. You could select the week commencement date on the second sheet and a formula on the main sheet would identify those records which fell into that week, and then other formulae on the second sheet would fill the appropriate data.

It would help in any case, if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete