Auto-update master sheet

[Sbrewer]

Hey all

So I need some help, I have been tasked with changing our report workbook so the master sheet auto-updates with information we have put in, in each week worksheet. Each worksheet including the master is set up the same. with 12 columns, 9 of which have headings, the other three includes the clients first and last name and their ID number and that isnt the worry. We want to be able to take the information we add in each weeks new worksheet and have it compiled with all of the weeks worksheets in the master list and matching in the appropriate column and client name row.

I know little about macros or how to write them. looking for some guidance on this I appreciate it.

[BadlySpelledBuoy]

Could you post a sample workbook? Ensure there is some representative data but desensitize it.
Also show some expected results, manually created if necessary.

BSB

[Mumps1]

It would be easier to help if you could attach a copy of your file with a detailed explanation of what you want to do referring to specific cells and sheets.