Excel VBA - Copy Data based on a cell value and filter to new sheet

First off, thank you in advance for your time and assistance! You all are geat and have been a huge help!

I want to add this function to my pre-existing macro called "Paste Values."

I would like for the value in H10 in Monthly Summary to be the filter value and essentially extract all values in Raw Data with that value in Column F and take all rows A:L and paste it into a new sheet.

So for example, if "1" is in H10 the new sheet would be called, "Accounting Data" and only contain values with 1 in Column F.

Thanks Again!

Hi all,

Still looking for some assistance on this.