Is there any possibility that i can retain data?

(e.g. Sheet 1 will read data from sheet 2 and when i remove raw data from sheet 2 it will remain and still reflect the removed data from sheet 2)