Pulling data from a worksheet with different columns to different sheets with names similar to the source column names

[jaredopondo]

Hi, I would like to get assistance on how to pull Data from a consolidated worksheet with a series of columns and rows to multiple sheets with sheet names similar to the consolidated sheet column names.

Many thanks