Hello,
Following are the steps I would follow to create a master list out of the data:
1. Segregating the data within numbered sheets by adding 4 columns (as per your given categories) and filling them with a value true or false
2. Once data is prepared, I would collate it in individual sheets for each category
3. Then fetching up the relevant information based on the categories you have given
4. Then last step would be to merge these 4 sheets together to create a master list
5. I would also like to propose you that, instead of renaming sheets, I can add hyperlink on first sheet to all the individual sheets, so that you can jump to particular sheet easily, but if you need I can rename them as well
For this, I would need following help from you,
1. To categorise some data, where no category is mentioned
2. Sheet "10" is in Chinese and there are others which have some words in chinese, how to handle them
We can discuss it on chat, if you have some time
Thanks and Regards,
Swapnil