For all rows where column M is blank, see the contents of A, C, F, L, M on another sheet?

[fitzchivalry]

Hi

I have some data with columns A - P on a sheet called PK2

For rows where column M is blank, I'd like to see the contents of A, C, F, L and M on a sheet called DS, in columns A - E.
I'd then like to have some more columns besides it (on the sheet called P3) and the info entered here doesn't need to find its way back to PK2.

Maybe this is why I shouldn't have my data in Excel? Or is this fine? Can I do this without Macros?

 

[fitzchivalry]

I think Power Query might be what I need, am about to watch this Dynamic filtering, fingers crossed :D