{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Price_Jan","Price_Feb","Price_Mar","Price_Apr","Price_May","Price_Jun","Price_Jul","Price_Aug","Price_Sep","Price_Oct","Price_Nov","Price_Dec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Price_Jan","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INDEX & FIND Function"]
[]
[null,"SheetNames"]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B5))","v":"Price_Jan"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B6))","v":"Price_Feb"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B7))","v":"Price_Mar"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B8))","v":"Price_Apr"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B9))","v":"Price_May"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B10))","v":"Price_Jun"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B11))","v":"Price_Jul"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B12))","v":"Price_Aug"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B13))","v":"Price_Sep"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B14))","v":"Price_Oct"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B15))","v":"Price_Nov"}]
[null,{"$f":"INDEX(MID(Worksheets,FIND(\"]\",Worksheets)+1,255),ROWS($B$5:B16))","v":"Price_Dec"}]

{"sheet":"Price_Feb","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Utilizing The INDEX Function"]
[]
[null,"S/N","SheetNames"]
[null,1,{"$f":"INDEX(SheetNames,B5)","v":"Price_Jan"}]
[null,2,{"$f":"INDEX(SheetNames,B6)","v":"Price_Feb"}]
[null,3,{"$f":"INDEX(SheetNames,B7)","v":"Price_Mar"}]
[null,4,{"$f":"INDEX(SheetNames,B8)","v":"Price_Apr"}]
[null,5,{"$f":"INDEX(SheetNames,B9)","v":"Price_May"}]
[null,6,{"$f":"INDEX(SheetNames,B10)","v":"Price_Jun"}]
[null,7,{"$f":"INDEX(SheetNames,B11)","v":"Price_Jul"}]
[null,8,{"$f":"INDEX(SheetNames,B12)","v":"Price_Aug"}]
[null,9,{"$f":"INDEX(SheetNames,B13)","v":"Price_Sep"}]
[null,10,{"$f":"INDEX(SheetNames,B14)","v":"Price_Oct"}]
[null,11,{"$f":"INDEX(SheetNames,B15)","v":"Price_Nov"}]
[null,12,{"$f":"INDEX(SheetNames,B16)","v":"Price_Dec"}]

{"sheet":"Price_Mar","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying TRANSPOSE Function"]
[]
[null,"GetSheetNames"]
[null,{"$f":"TRANSPOSE(GetSheetNames)","v":"[Sheet Name List.xlsm]Price_Jan"}]
[null,"[Sheet Name List.xlsm]Price_Feb"]
[null,"[Sheet Name List.xlsm]Price_Mar"]
[null,"[Sheet Name List.xlsm]Price_Apr"]
[null,"[Sheet Name List.xlsm]Price_May"]
[null,"[Sheet Name List.xlsm]Price_Jun"]
[null,"[Sheet Name List.xlsm]Price_Jul"]
[null,"[Sheet Name List.xlsm]Price_Aug"]
[null,"[Sheet Name List.xlsm]Price_Sep"]
[null,"[Sheet Name List.xlsm]Price_Oct"]
[null,"[Sheet Name List.xlsm]Price_Nov"]
[null,"[Sheet Name List.xlsm]Price_Dec"]

{"sheet":"Price_Apr","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using LOOKUP Function"]
[]
[null,"Sheets"]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B1))))","v":"Price_Jan"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B2))))","v":"Price_Feb"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B3))))","v":"Price_Mar"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B4))))","v":"Price_Apr"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B5))))","v":"Price_May"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B6))))","v":"Price_Jun"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B7))))","v":"Price_Jul"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B8))))","v":"Price_Aug"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B9))))","v":"Price_Sep"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B10))))","v":"Price_Oct"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B11))))","v":"Price_Nov"}]
[null,{"$f":"LOOKUP(\"xxxxx\",CHOOSE({1,2},\"\",INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROWS(B$1:B12))))","v":"Price_Dec"}]

{"sheet":"Price_May","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUBSTITUTE Function"]
[]
[null,"S/N","Dynamic List of SheetNames"]
[null,1,{"$f":"INDEX(Dynamic_List_of_SheetNames,B5)","v":"Price_Jan"}]
[null,2,{"$f":"INDEX(Dynamic_List_of_SheetNames,B6)","v":"Price_Feb"}]
[null,3,{"$f":"INDEX(Dynamic_List_of_SheetNames,B7)","v":"Price_Mar"}]
[null,4,{"$f":"INDEX(Dynamic_List_of_SheetNames,B8)","v":"Price_Apr"}]
[null,5,{"$f":"INDEX(Dynamic_List_of_SheetNames,B9)","v":"Price_May"}]
[null,6,{"$f":"INDEX(Dynamic_List_of_SheetNames,B10)","v":"Price_Jun"}]
[null,7,{"$f":"INDEX(Dynamic_List_of_SheetNames,B11)","v":"Price_Jul"}]
[null,8,{"$f":"INDEX(Dynamic_List_of_SheetNames,B12)","v":"Price_Aug"}]
[null,9,{"$f":"INDEX(Dynamic_List_of_SheetNames,B13)","v":"Price_Sep"}]
[null,10,{"$f":"INDEX(Dynamic_List_of_SheetNames,B14)","v":"Price_Oct"}]
[null,11,{"$f":"INDEX(Dynamic_List_of_SheetNames,B15)","v":"Price_Nov"}]
[null,12,{"$f":"INDEX(Dynamic_List_of_SheetNames,B16)","v":"Price_Dec"}]

{"sheet":"Price_Jun","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying VBA Code"]
[]
[null,"Sheet Names"]
[null,"Price_Jan"]
[null,"Price_Feb"]
[null,"Price_Mar"]
[null,"Price_Apr"]
[null,"Price_May"]
[null,"Price_Jun"]
[null,"Price_Jul"]
[null,"Price_Aug"]
[null,"Price_Sep"]
[null,"Price_Oct"]
[null,"Price_Nov"]
[null,"Price_Dec"]

{"sheet":"Price_Jul","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Price_Aug","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Price_Sep","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Price_Oct","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Pr"]

{"sheet":"Price_Nov","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["P"]

{"sheet":"Price_Dec","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}