Hello everyone....been struggling with my two workbooks for the past days...need your inputs on this...

i have 2 workbooks say WB1 and WB2
in WB1, i have two main columns (CA and CB), CA is the Month Column and CB is a Count (from other worksheet)
in WB2, i have several sheets with a Table inside, Sheetname is the Month name, Table range inside each sheet is from column A5 to F(Count)

Now, I want to write a code in WB1 that will update the Table Range in each Sheet in WB2.
Goes something like this...
get the range of WB1 CA (starts from A7 down)
for each CA (month), check WB2 if there is a sheet named CA (month)
if sheetname is found in WB2, set the table range for that sheet from A5 to F(value of WB2 CB(Count))
next CA
end

Tia!