You would probably want a looping macro to get the data from each sheet and
place at the next available row in the destination sheet.

for each ws in worksheets
dlr=sheets("master").cells(rows.count,1).end(xlup) .row+1
ws.range("ddd").copy sheets("master").cells(dlr,1)
next ws



--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kim" wrote in message
...
I want to pull data from several worksheets based on a date range, put them
in a new worksheet to then utilize that data. Help?