VB Code to consolidate data

Hello:

Please refer to attached file.
I have data in each store sheet in Column Q thru AD and i need VB Code to consolidate as follows in "Consolidate" sheet.

Need Data Range ("Q6:AD78") from each Store sheet (except excluded sheets listed in cell A24 down in Sheet Consolidate) and paste at designated cell shown in column B for that store and write name of the store in column D.

Example:
I have manually pasted Store1 data @ E1 and then added Store1 in column D.
I have manually pasted Store2 data @ E101 and then added Store2 in column D

Same way need to copy range ("Q87:AD150") and paste at designated cell shown in column C for that store and write name of the store in column D.

Let me know if you have any questions.
Thanks.

Maybe

Please Login or Register  to view this content.

Hello Fluff13:

Thanks a lot, it works.
Will inform you if further help is needed in this.

Riz

Glad to help & thanks for the feedback