How to auto populate multiple data sets from sheet to another

[karlomercene]

I have a spreadsheet that collects data from a Microsoft Form. Is there a way for me to have data from multiple columns (for example, columns B:G) populate another sheet? I know nothing about Excel so please be kind. Thanks.

 

[karlomercene]

I have a spreadsheet that collects data from a Microsoft Form. Is there a way for me to have data from multiple columns (for example, columns B:G) populate another sheet? I know nothing about Excel so please be kind. Thanks.

I should add, I only need the data copied if the answer in let's say column A is filtered.

If Column A is "Option 1", then copy data from columns B:G. I hope that makes sense?