I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all these 50 sheets. I do not wish to have all the data from these sheets. I just want to automatically copy or insert certain rows to my summary sheet. I am saying auto because I want to type in a certain sheet and it automatically copy into my summary sheet.
Which column are you using as the "key"? That is, in which column will your last entry be made and will this column have a specific criteria (such as "Yes" or "Completed" or "Done and Dusted" etc.) to initiate the code?
It would be best if you could upload a sample of your work book ( just a few rows from each sheet --->just a few sheets not all fifty) to a free file sharing site such as Sendspace, ge.tt or DropBox and then post the link to your file back here. Please use dummy data.
We will then have a better understanding of your query.