Consolidate data from several sheets to a summary sheet

[racdac]

Hi All,

I have a workbook with several sheets containing results. I want to copy some of the data from each sheet to a summary sheet.

I will be adding more result sheets to the workbook each week. Ideally i would like to have the summary sheet update automatically, but running a macro is ok.

Becuase only some of the data is needed in the summary sheet, I thought rather than posting images I would post a link to the file.

The summary sheet just has links to the data that is needed to show any potential helpers where the data needs to come from. I hope this is Ok.

Any help would be appreciated.

Test results

 

[racdac]

Re: Don't display or Remove error from cell

Hi Oeldere,

We need separate sheets for each client as it contains photgraphs as well as data. We will be sending the data sheets to other therapists then collating the data.

Thank you for your interest.