Pulling for multipul work sheets into one master work sheet

[boll55]

I have a work book with prob close to a thousand individual work sheets in it. I have a goup of cells that are the same in ever work sheet that I would like to pull and place into a master work sheet. I dont want to copy and paste each one, I'd be a hundred before I finished and I dont have that kind of time. Im thinking a macro might be what I need but Im not very good with useing them let alone making one to fit me needs.

Any help would be so much appreciated.

Thanks

 

[Trevor G]

You could something like this

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> rangeCopy()<br><SPAN style="color:#00007F">Dim</SPAN> ws <SPAN style="color:#00007F">As</SPAN> Worksheet<br><SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> ws <SPAN style="color:#00007F">In</SPAN> Worksheets<br>    <SPAN style="color:#00007F">If</SPAN> ws.Name <> "Summary" <SPAN style="color:#00007F">Then</SPAN><br>    ws.Activate<br>    Range("A2:A17").Copy<br>    ws("Summary").Activate<br>    Range("A65536").Select<br>    Selection.End(xlUp).Select<br>    ActiveCell.Offset(1).Select<br>    ActiveSheet.Paste<br>    <br><SPAN style="color:#00007F">Next</SPAN> ws<br>Application.CutCopyMode = <SPAN style="color:#00007F">False</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[boll55]

Ok than works kind of but i need it modified and i cant do that.....

the data i have is in cells L4 through R4....


Can you help me