Modifying Dataset and Copying Over to Sheets

[ultralightbeam]

Hi, I'm new to making and using macros, I was wondering if anyone can help me program the following if its not too much work. I've tried making something similar with recording, but it doesnt come out right. Any help would be appreciated!


Background:
Dataset in 1 Sheet with ~200K lines, looking to replace some of the dataset based on lookup tables and output them by region (separate tabs)
Macro To do:
1. Using raw data set (tab called "Page1"), replace fields in column K based on lookups in table called "Business", only if column AE is on a table called "City", otherwise paste value from column AE
2. Each Tab is a Region Name (Canada, USA, etc). If Tab name matches Column AK, copy each line starting on row 10 for the following:
- Column AK (from "Page1")
- Column AE (from "Page1")
- Column AG (from "Page1")
- Column K (from "Page1")
- Leave as blank
- Look up Column T, if maching value as "Jan", then paste value from Column N

I do have an example of the file, but not sure how I can attach here.

Thank you so much!