How to append sheets/consolidate multiple sheets in one sheet

Hi All,

here are two different sheets populated from two different forms which are site specific

The forms have information for people to read which are site specific hence why two forms

Is there a way to append these two sheets into one like you can do on power bi using the append query function?

please can you advise