|OK, so we are starting from scratch. No problem, but I have a couple of questions first.|
Please keep in mind that even though you said "I created with 8 different worksheets that all have the same format", we can't see your workbook from where we are sitting and therefore have no idea what that "format" looks like.
If the sheets are laid out so that the date you are looking for is in a specific
column (e.g. A) and you want to copy the entire row each time the date is found in that column, then the code will be very straight forward: Search Sheet1!Column A for the date in Summary!C7 and copy the entire row when found. Then search again and copy again if found. Once Sheet1 has been exhausted, move on to Sheet2 and do it all again.
A loop within a loop is all that is needed.
However, if the the sheet is laid out such the date could be anywhere or if multiple rows need to be copied for each date then things get more complicated.
Can you tell me something about the layout the sheets?
Another question: Is the goal to clear the Summary sheet and populate it with new data each time the button is clicked or is the new data being appended to bottom of the existing data? Both of those actions a pretty easy. However, if you tell me that you want to replace existing data on an individual basis, here and there throughout the sheet, the level of complexity goes up considerably.
Tell us more about what you are trying to do and we'll see if we can help.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.