If command to copy content to new Sheet

[Robmcnz]

Hello...

I have a spreadsheet that I need to separate the data into various spreadsheets based on values. I need to move each line of data into separate sheets based an a value that will be listed in cell d4. In cells d1,d2,d3,d5-10 is content that I need to copy into different sheets. So if I have 10 lines have the with the value of 18777, I want to copy those 10 lines into a sheet that I can then run graphs against.

Not sure I have described this very well. Essentially I have content that I need to separate into their own sheet so that I can create graphs based on that copied data. Each line has about 10 values which will get picked up based on a value that will appear in the same column. I was thinking that I could use the if command to pick up the data but just not sure on the right context to use to achieve this.

I have attached a file that loosely shows what I want to do. Sheet 2 shows that I have copied id 12345 plus all content into it's own spreadsheet. I want to do this by command as there will be hundreds of lines to be copied so don't really want to do it manually.

If anyone can help me here that would be much appreciated! Hopefully I have described things well enough.