Somewhat complex document; problems extracting and organizing data from cells

I'm not too sure how to explain the problem so I attached the file here. The data is in column A of Sheet3 and Sheet1 is what I want the data to look like. Everything else in the document is what I've tried so far but nothing seems to work and I've been trying for hours. I want the document to extract the chip size of every player in each hand and organize it like in Sheet1.

Sheet2 extracts the numbers but only gives 3 numbers when the number has 4 digits and Sheet3 includes the parentheses in triple digit numbers . Even if I did manage to extract the numbers correctly, I'm not too sure how to put them neatly like on Sheet1. Any help would be greatly appreciated!

Wow thank you very much, this is exactly what I wanted! Two small things though: chips can sometimes be 2 digits long but never 1 or 5. Also, I would prefer have them sorted by position than by seat #. Position changes every turn and the cell above the first seat tells which seat has the position 'Button' or BU.

If there are 6 players and seat #1 has button, seat #2 will have SB, seat #3 BB, #4 UTG, #5 MP and #6 will have CO.
If #2 has button then #3 has SB, #4 BB, #5 UTG, #6 MP and #1 CO and so on. If there are 5 players then there is no MP and if there are 4 players there is no MP and no UTG. If there are only 3 players (the minimum) then there is only BU, SB and BB. What would be the formula to get the seat with the button for each hand? I can make another sheet that gets the chip counts from Sheet1 and rearranges them but I need to know which seat has the button and I don't really understand the formula even though it works well.

Thanks again for the hepl!

You guys are fantastic, thank you so much!