I am trying to create a set of spreadsheets that track expenses. I have a sheet "Record" that I would like to have data copied from into a series of other sheets based on the values of cells in a specific column. For example, I'm recording expenses, one of the columns of data is "production name," and I'd like to copy the remaining data into a new sheet for each unique show. I don't think Vlookup would work because I'm looking to copy several records across a number of dates, which is one of the other data columns.

I'm not a VB guy, so I'm kind of clueless. Any help is appreciated.