macro to copy data in master sheet - issue

hello

i have the following macro that copies data from sheet2, sheet 3, sheet 4 and consolidates it into "master" sheet.

Please Login or Register  to view this content.

i am not well versed with macros so need some help pls...

1) the macro is not going to sheet2, sheet 3, sheet 4 to extract the data from
2) how can i make my range dynamic. for example, my range is C9:BB400.
-can i make it so the range is C9:BBxxx (where xx is the last active data cell in the range?)

can someone pls help...it will prob take a pro a few seconds. thx u