How to make it flexible and it wont fix on the size of the
data? How to make the pivot table will expand follow by the expands of
data?

Create a dynamic named range for your source data - see
http://www.contextures.com/xlNames01.html#Dynamic

Rgds,
Andy