HELP pls..urgent

[Bilaal xaka]

Hello everyone,
I need your help pls.
I have a workbook where there are 5 sheets, each sheet with 3tables, and every sheet has the same table size and column with same header at the exact cell number, but different data within each table.(pls find attached)
Is it possible than I sort all the 3 tables of all the 5 sheets (15 tables) in ascending order in cells C1, B16& I16 at one go?

 

[Bilaal xaka]

Hey Zot,
Thanks. you are the best.

Hey Zot, suppose there are 30 sheets in my workbook, namely:
Sheet 1, Sheet 2,... to Sheet 30.
Sheet 1 to Sheet 25 is visible.
Sheet 26 to Sheet 30 is hidden.
And that I had to apply this VBA only on Sheet 1 to Sheet 20.
How can I modify this VBA? And do VBA affect hidden sheets?

Pls help. Thanks Zot.

 

[Zot]

Hey Zot, suppose there are 30 sheets in my workbook, namely:
Sheet 1, Sheet 2,... to Sheet 30.
Sheet 1 to Sheet 25 is visible.
Sheet 26 to Sheet 30 is hidden.
And that I had to apply this VBA only on Sheet 1 to Sheet 20.
How can I modify this VBA? And do VBA affect hidden sheets?

Pls help. Thanks Zot.

The VBA code is placed in normal module, not under any sheet. You can call the macro program after you open workbook by pressing Alt+F8 and run the program you desired. It has nothing to do with whichever sheet is visible or hidden. The program will loop through all sheets and skip the hidden one.

 

[Bilaal xaka]

The VBA code is placed in normal module, not under any sheet. You can call the macro program after you open workbook by pressing Alt+F8 and run the program you desired. It has nothing to do with whichever sheet is visible or hidden. The program will loop through all sheets and skip the hidden one.

ZOT,
Huge huge thanks.
Sorry for the lateness.
Got caught with a deadline at work