Generate excel reports depending on user defined values

Hello Experts,

need your assistance..

I have a set of data in Sheet "Main"
from Column A to Column T

I have to create a Button which will generate 2 reports depending on the user-defined input in Sheet "BucketList"

i have manually added Column U, V, W inorder to generate the reports in pivot but this columns willl not be present. user will only have column A to Column T
Column U = Bucket value slab from column G
Column V = Positive value from column S
Column W = Negative value from column S


Pivot Reports..

Reports NAme (PerBooks & Pername)

i have attached a sample pivot but for which i have to take Column U...
How can we automate this so that user will update the BucketList values & the reports will be generated on the basis of it..

User do not want pivots.. they just want the data on button click & after changing the BucketList values.

I have got the code which will convert the Pivot table to SUMIFS formula..

but I have to generate reports on the basis of user defined values

I have got the SUMIFS formula for the reports... but the reports should be done only on the basis of
Bucket list (User-defined value)


Please see the file & advice me