conditional copy data from multiple workbooks

i want to copy the first 8 columns of data from every row in specified sheets in several workbooks if the column a value is "1" and paste it all into the first 8 columns of a new worksheet in the active workbook.

Can someone help with this please?

I've checked the forum and googled it but there are so many references I'm completely confused.

Any help would be appreciated and example data attached

Thanks

Louise