Loop sheet for copy data?

I want to copy data some column from every sheet. (except sheet Detail_CC , CC , sheet that hide)

From file Excel.
input.xlsx (41.1 KB)

I want copy data from sheet C_Apr & C_1-31 Aug to sheet Paid (another sheet in condition except)

Column A in sheet Paid.
I want to read number lot from file config1 and run sequence Lot62(1) , Lot62(2) , …
config1.xlsx (8.6 KB)

remark : I delete sensitive data , read data have about 1k.

Please guide me about it.

Hi @fairymemay ,

To copy the sheet, take a look at this thread.