Hi

I have a spreadsheet with the following columns

A= staff number, B= Staff Name, C= Manager number, D= Manager Name, E= Learning 1, F= Learning 2, G= Learning 3, H= Learning 4, I= Learning 5

Example

staff number Staff Name Manager number Manager Name Learning 1 Learning 2 Learning 3 Learning 4 Learning 5
1012 J Bloggs 15 A Anderson 23/09/2016 01/04/2015 26/04/2016 15/03/2014
1065 H Simpson 24 C Ronaldo 01/04/2015 26/04/2016 15/03/2014
1132 R Geller 15 A Anderson 01/04/2015 26/04/2016 15/03/2014 20/09/2013 31/01/2017



There are 524 rows in the list. The spreadsheet shows the dates each of the learning modules was completed.

Some staff have not completed each of the modules, or have not completed the database form on their desktops which populates the list.

I want to extract the rows where at least one of the columns E to I is empty onto a blank copy of the spreadsheet which I want to have as sheet 2 of the workbook.
I also need it to be in order of manager name or number (it doesn't matter which)

Also If possible I'd like it if it's possible for the sheet to auto update if the main spreadsheet is ever updated. Whether thats by button click or just formula's on the worksheet

Thanks