Query questions

hi all,

Yesterday we had a presentation with the end-users showing them how the report on Bex looks like and they weren't too happy about it. They want a certain things to be included in the query. They want a workbook which has different queries on each tab, which i know how to do it, and they want each tab to be refreshed with most updated data without making a selection in the parameter, filter in this case. How can i do this ?.

I was thinking to remove the posting period and fiscal year from the Filter, but will the query take the most updated data ? i understand their frustrations since they never seen Bex before.

I will appreciate any input or suggestions in how to make this report more understandable for them