How to synchronize two sheets in Google Sheets so that information from one sheet is transferred to another automatically?

Question

Google Sheets

How in google sheets can you automate the transfer of data from one sheet to another, but at the same time to enter data manually at the same time?

For example, https://docs.google.com/spreadsheets/d/1ZoL_FmO-xw...
I need to automatically get data from "Sheet 2" to "Sheet 1". They can be pulled up by the IMPORTRANGE formula, but this formula does not allow you to enter data manually. When you enter the formula stops working and throws an error.

Tried the formula:

=ЕСЛИОШИБКА(FILTER({'Лист2'!A4};НЕ(ЕПУСТО({'Лист2'!A4})));"-")

But it also does not allow you to enter data manually, as it is attached to a specific cell.