Hundreds of sheets, trying to loop through and extract specific columns

[happy_camper]

Thank you JKwan. I will look Power Query up and google and try to figure it out. Thank you