Macro needed? Extracting Data from multiple worksheets into a master worksheet Excel 2010

[reallyseriousllly]

Hi, I am new here (obligatory comment!)


I would really appreciate help with the following: I have a workbook with multiple worksheets, each worksheet is a client with a a list of pending payments and dates (among other info). My boss wants a "cover" worksheet that pulls the information of the worksheets (each are a name of a client) into a master client list with headings of the last Friday of each week of this year. She wants the amount of money that is owed for that week tracked in one spot where she can see, each week, what to expect for income.


Can this be done? Will I need to do a macro for it? and how the hell do I do that?

Here is an example

Master worksheet:
Client 2/14/14 2/21/14 -----etc to the end of the year.
Smith
Jones
James


Sample worksheet

ColumnD Column E
[TABLE="width: 148"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2/14/2014[/TD]
[TD]$400.00[/TD]
[/TR]
[TR]
[TD]3/15/2014[/TD]
[TD]$400.00[/TD]
[/TR]
[TR]
[TD]4/15/2014[/TD]
[TD]$3,200.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much for any help that anyone provides!! Also, please be patient if I come back with more questions because this stuff is about the same as learning ancient Sumarian to me.