copying data

[MAMIBUSSOL]

I have 52 payslip layouts in a worksheet

layouts 1 - 13 start at cell W1
layouts 14 - 26 start at cell W24
layouts 27 - 39 start at cell W46
layouts 40 - 52 start at cell W69

each layout has a week number

I want to do the following

1) ask user for a week number
2) search the worksheet for the appropriate week number
3) select the layout in question
4) copy the layout only to a new workbook
5) repeat the process for each worksheet

any help with this process would be appreciated