Array cannot allow me to sort data

Hello everyone,

I'm a bit headache with an Excel file. The file has two tabs: 'Input' and 'Master'. The 'Input' tab is for users to input any new records, and the 'Master' tab is to retrieve data from the 'Input' tab. Given that some users may want to insert a row in between (rather than add at the bottom), I used arrays in the 'Master' tab such as: ={IF(ISERROR(1/Input!E2:E250),"",Input!E2:E250)}. Now there came the problem: in the 'Master' tab, the data cannot be sorted when the arrays are used. Otherwise, there is a warning message: You cannot change part of an array.

Can you please give any good advice to overcome this problem?

The 'Master' tab has other columns which need to be sorted. So cannot just sort the source data.

It seems that as long as there is an array, sorting won't work. Must I change to non-array based formulas?