How to batch link data from multiple cells into another sheet in the same work book?

Hi.
I have a sheet inside of a workbook that has confidential information on part of the sheet. I want to have another sheet with the same information minus the confidential info. The goal is to be able to edit the master sheet and information would go directly into the viewing sheet. I've found plenty online on how to link one individual cell and that works just fine. But, the issue is that the sheet has well over 600 rows and I don't have the time to do that for each one. I've attached a small example workbook. Sheet 1 has orange columns and a few blue columns. Sheet 2 only has the orange columns and I want those cells to be exact replicates and that update when changed in Sheet 1. Sorry if this is obscure but any help would be gladly appreciated.

Thanks,
njc007

You can use this formula in cell A2 of Sheet2:

=IF(Sheet1!A2="","",Sheet1!A2)

Copy across to D2, then copy those 4 formulae down as far as you need them.

Hope this helps.

Pete

Thank you so much!