I Have a workbook which consist of 6 pages or sheets.

The first 4 pages collect data by importing it from other areas such as
website and other workbooks.

the other 2 pages I created tables so I can cleanly filter the information.

I recently figured out how to run a macro to sort data between a range, but
I manually have to run the macro everytime the data gets updated.

Is there way to automatically run a macro everytime the data changes?